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

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.