Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
lbelcher lbelcher
wrote...
Posts: 482
5 years 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
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 96 times
1 Reply
Replies
Answer verified by a subject expert
NashuaNashua
wrote...
Posts: 380
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here

Related Topics

lbelcher Author
wrote...

5 years ago
Good timing, thanks!
wrote...

Yesterday
this is exactly what I needed
wrote...

2 hours ago
Brilliant
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  907 People Browsing
 113 Signed Up Today
Related Images
  
 391
  
 278
  
 226