what is difference between natural key and primary key?
The primary key is a unique value that identifies each record. ... A natural key is a single column or set of columns that uniquely identifies a single record in a table, where the key columns are made up of real data. When I say “real data” I mean data that has meaning and occurs naturally in the world of data.