Question: what is difference between surrogate key natural key and primary key?
Answer: A primary key is a special constraint on a column or set of columns. ... A table may have only one primary key, but it may be composite (consist of more than one column). A surrogate key is any column or set of columns that can be declared as the primary key instead of a "real" or natural key.