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.

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

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

Create a visual representation of your database design as a Crows Foot E-R diagram similar to the one in Figure 6-39.

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.