What is an artificial (derived) primary key? When should it be used?
Submitted by: Administrator
Using a name as the primary key violates the principle of stability. The social security number might be a valid choice, but a foreign employee might not have a social security number. This is a case where a derived, rather than a natural, primary key is appropriate. A derived key is an artificial key that you create. A natural key is one that is already part of the database.
Submitted by: Administrator
Read Online Data Modeling Job Interview Questions And Answers
