A surrogate key provides immutability because it is assigned and therefore its value need never change even as other data values change. Surrogate keys also provide uniformity and compatibility. If ...

A surrogate is, 'One appointed to act in place of another.' A surrogate key is appointed to act in place of a natural key. Why? Well, one could argue that surrogate keys existed since the beginning of ...