Multiple Choice
For the M-O (parent mandatory,child optional) case,what action(s) should be taken to ensure minimum cardinality is maintained?
A) Define referential integrity constraint from child to parent
B) Make foreign key NOT NULL
C) Will require trigger or other application code
D) Both A and B are correct
Correct Answer:

Verified
Correct Answer:
Verified
Q79: A referential integrity constraint policy that insures
Q80: An intersection table can have additional attributes
Q81: A key of an intersection table is
Q82: What are MUST NOT and MUST COVER
Q83: In relational database design,ID-dependent entities are not
Q85: Referential integrity constraints should disallow adding a
Q86: To represent an N:M relationship in a
Q87: Explain the representation of a many-to-many strong
Q88: In many-to-many relationships between strong entities in
Q89: To represent a 1:1 binary relationship in