Question

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 parent updates to cascade and child updates to cascade are correct

Answer 1

In an ID-dependent E-R data model relationship, the referential integrity constraints should allow both parent updates to cascade and child updates to cascade.

Step-by-step explanation:

When transforming an ID-dependent E-R data model relationship into a relational database design, the referential integrity constraints should allow both parent updates to cascade and child updates to cascade.

This means that if the parent's primary key is updated, the corresponding child records will also be updated with the new parent key value.

Similarly, if a child's primary key is updated, the corresponding parent records will be updated.