When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.
A)the parent entity must also use a surrogate key
B)the relationship remains an ID-dependent relationship
C)the relationship changes to a non-ID-dependent relationship
D)A and B
E)A and C

Question

Quizplus · Accepted Answer

When a child entity uses a surrogate key, the relationship changes to a non-ID-dependent relationship because the surrogate key replaces the need for the child entity's primary key to include the parent's primary key.

When Transforming an ID-Dependent E-R Data Model Relationship into a Relational