Question
What is an artificial (derived) primary key? when should it be used?

Answers

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.   Your Comment






Search
Can you Answer!!
  • Q Which painting was stolen from the Louvre in Paris in 1911 and kept for two years by museum employee Vincenzo Peruggia?
  • Q What is a simple php method to make a cross domain data request?
  • Q Why do you wish to stay for so long?
  • Q Main method from another class?
  • Q One who believes in giving equal opportunity to women in all fields
  • Q How do you invoke a Servelt? What is the difference in between DoPost and doGet methods ?
  • Q What is atom publishing protocol (app)?
  • Q What is the advantage of Ring network ?
  • Q describe about BLOB in sql?
  • Q Write the torsion equation?
  • Q Does nhibernate modify my il? if not, how do you know what has changed?