Question 1: Convert this data model to a database design. Specify tables, foreign keys and primary keys, using figure 6-41 as a guide, specify column properties.
Question 2: Describe how you have represented weak entities, if any exist.
Question 3: Describe how you have represented super type and subtype entities, if any exist.
Question 4: Create a visual representation of your database design as a crow's Foot E-R diagram similar to the one in figure 6-37.
Question 5: 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.
Explain how you show the represented weak entities and how you show the database design.