Question: Select one condition that suggest a surrogate key should be created for the primary key of a relation. The natural primary key ( the one

Select one condition that suggest a surrogate key should be created for the primary key of a relation.
The natural primary key (the one initially identified by users during conceptual modeling activities) is too long or made up of more than two attributes which will cause performance issues with the implementation.
The absence of a composite primary key.
The natural primary key requires duplicates or re-use over time.
 Select one condition that suggest a surrogate key should be created

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!