Case Study 6

Instructions

• Answer questions A through E of the Morgan Importing Project found on page 321.
• Create and set up the MI_CH02 database with the given SQL files.
• Deliver a single document.
• These questions require answering the Morgan Importing Project questions at the end of Chapter 5.

Questions MI.A - MI.E

A.) Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties.

B.) Describe how you have represented weak entities, if any exist.

C.) Describe how you have represented supertype and subtype entities, if any exist.

D.) Create a visual representation of your database design as a Crow’s Foot E-R diagram similar to the one in Figure 6-39.

E.) Document your minimum cardinality enforcement using referential integrity actions for required parents, if any, and the form in Figure 6-29(b) for required children, if any.