Top Posters
Since Sunday
25
24
23
22
22
22
22
21
21
21
21
20
New Topic  
wrote...
Posts: 111
2 months ago
For the M-O (parent mandatory, child optional) case, what action(s) should be taken to ensure minimum cardinality is maintained?

• Define referential integrity constraint from child to parent

• Make foreign key NOT NULL

• Will require trigger or other application code

• Both Define referential integrity constraint from child to parent and Make foreign key NOT NULL are correct
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 15 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 104
2 months ago
Sign in or Sign up in seconds to unlock everything.
Both Define referential integrity constraint from child to parent and Make foreign key NOT NULL are correct
Related Topics
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  168 People Browsing
 141 Signed Up Today
Related Images
 1489
 371
 114