Explain the need for each of the design decisions in Figure 6-34. Design Decisions to Be Made

Explain the need for each of the design decisions in Figure 6-34.

Transcribed Image Text:

Design Decisions to Be Made Design Documentation Relationship Minimum Cardinality • Update cascade or prohibit? • Delete cascade or prohibit? • Policy for obtaining paront on insort of child M-O Referential integrity (RI) actions plus documentation for policy on obtaining parent for child insert. • Policy for obtaining child on insert of parent • Primary key update cascade or prohibit? • Policy for update of child foreign key • Policy for deletion of child All decisions for M-O and O-M above, plus how For mandatory parent, RI actions plus documentation for to process trigger conflict on insertion of first instance of parent/child and deletion of last instanco of paront/child. Use Figure 6-28(b) as a boilerplate. O-M М-м policy on obtaining parent for child insert. For mandatory child, use Figure 6-28(b) as a boilerplate. Add documontation on how to procoss triggor conflict.