When transforming an ID-dependent E-R data model relationship into a relational database design,the referential integrity constraints should allow ________.
A)parent updates to cascade
B)child updates to cascade
C)child deletes to cascade
D)A and B
E)A,B,and C

Question

Quizplus · Accepted Answer

In an ID-dependent E-R data model, the child entity's existence is dependent on the parent entity. Therefore, when a parent entity is updated, the changes should cascade to the child to maintain referential integrity.

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