Saved Bookmarks
| 1. |
What Is A Surrogate Key? |
|
Answer» In normal PRACTICE, a numerical attribute is enforced a PRIMARY key which is called as surrogate key. Surrogate key is a SUBSTITUTE for natural keys. Instead of having primary key or COMPOSITE primary keys, the data modelers create a surrogate key; this is very useful for creating SQL queries, uniquely identify a record and good PERFORMANCE. In normal practice, a numerical attribute is enforced a primary key which is called as surrogate key. Surrogate key is a substitute for natural keys. Instead of having primary key or composite primary keys, the data modelers create a surrogate key; this is very useful for creating SQL queries, uniquely identify a record and good performance. |
|