Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Exercise 4

Answer Project Question 5.59 if you have not already done so. Design databases for your model in Project Question 5.59(a) and for the model in Figure 5-57. Your designs should include a specification of tables and attributes as well as primary, candidate,and foreign keys. Also specify how you will enforce minimum cardinality. Document your minimum cardinality enforcement using referential integrity actions for required
parents, if any, and the form in Figure 6-28(b) for required children, if any.