Saved Bookmarks
| 1. |
Need For Surrogate Key Not Primary Key |
|
Answer» If a column is made a primary key and later there NEEDS a CHANGE in the data TYPE or the length for that column then all the foreign keys that are dependent on that primary key should be changed MAKING the database Unstable . Surrogate Keys make the database more STABLE because it insulates the Primary and foreign key relationships from changes in the data types and length. If a column is made a primary key and later there needs a change in the data type or the length for that column then all the foreign keys that are dependent on that primary key should be changed making the database Unstable . Surrogate Keys make the database more stable because it insulates the Primary and foreign key relationships from changes in the data types and length. |
|