what is the difference between surrogate key and natural key?
A natural key is a column value that has a relationship with the rest of the column values in a given data record. ... A surrogate key like a natural key is a column that uniquely identifies a single record in a table. But this is where the similarity stops. Surrogate keys are similar to surrogate mothers.