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 the relationship changes to a weak but not ID-dependent relationship.

Question

Quizplus · Accepted Answer

When a surrogate key is used in the child entity, the relationship becomes weak but not ID-dependent because the parent entity's primary key is no longer necessary for identifying the child records.

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