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

6.55 Answer Project Question 5.60 if you have not already done so. Design a database for
your model in Project Question 5.60(e). Your design 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 enforce-
ment using referential integrity actions for required parents, if any, and the form in
Figure 6-28(b) for required children, if any.
6.56 Answer Project Question 5.61 if you have not already done so. Design a database for
your model in Project Question 5.61(c). Your design 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 en-
forcement using referential integrity actions for required parents, if any, and the form
in Figure 6-28(b) for required children, if any.
6.57 Answer Project Question 5.62 if you have not already done so. Design a database for
your model in Project Question 5.62(d). Your design 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 enforce-
ment using referential integrity actions for required parents, if any, and the form in
Figure 6-28(b) for required children, if any.
Case Questions
Washington State Patrol Case Questions
Answer the Washington State Patrol Case Questions in Chapter 5 if you have not already done
so. Design a database for your data model from 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 ac-
tions for required parents, if any, and the form in Figure 6-28(b) for required chil-
dren, if any.
San Juan Sailboat Charters Case Questions
San Juan Sailboat Charters (SJSBC) is an agency that leases (charters) sailboats. SJSBC does
not own the boats. Instead, SJSBC leases boats on behalf of boat owners who want to earn in-
come from their boats when they are not using them, and SJSBC charges the owners a fee for
this service. SJSBC specializes in boats that can be used for multiday or weekly charters. The
smallest sailboat available is 28 feet in length and the largest is 51 feet in length.
Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided
at the time of the charter. Most of the equipment is provided by the owners, but some is
provided by SJSBC. The owner-provided equipment includes equipment that is attached to
the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and
refrigerators. Other owner-provided equipment, such as sails, lines, anchors, dinghies, life