When transforming an ID-dependent E-R data model relationship into a relational database design where the child entity is designed to use a surrogate key,the relationship changes to a weak but not ID-dependent relationship.

Question

Quizplus · Accepted Answer

When using a surrogate key in the child entity instead of relying on the parent entity's ID as a foreign key, the relationship becomes weak but not ID-dependent. This is because the child entity no longer relies on the parent entity's ID as a primary key.

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