Question: Provide an example of when a surrogate primary key would be preferred over a natural key. Explain the circumstances where composite primary keys are appropriate.
- Provide an example of when a surrogate primary key would be preferred over a natural key.
- Explain the circumstances where composite primary keys are appropriate. Give an example.
- Which is better - a natural key or a surrogate key? Explain your reasoning.
- What are some of the potential risks that arise when using surrogate keys in place of natural keys?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help