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)Both A and B are correct

Question

Quizplus · Accepted Answer

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

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