Transforming Data Models into Database Designs - Database Processing: Fundamentals, Design, and Implementation - page 275

this model relates EQUIPMENT to CHARTER rather than BOAT even when the equipment is
physically attached to the boat. This is only one possible way to handle EQUIPMENT, but it is
satisfactory to the managers of SJSBC.
a. Convert this data model to a database design. Specify tables, primary keys, and foreign
keys. Using Figure 6-41 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-37.
e. 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.
If you have not already done so, complete The Queen anne Curiosity Shop project at
the end of Chapter 5.
a. Convert this data model to a database design. Specify tables, primary keys, and foreign
keys. Using Figure 6-41 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-37.
e. 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.
If you have not already done so, complete the Morgan Importing project at the end of
Chapter 5.
a. Convert this data model to a database design. Specify tables, primary keys, and foreign
keys. Using Figure 6-41 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-37.
e. 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.