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

6.37 Describe a MUST NOT constraint. Give an example other than one in this chapter.
6.38 Describe a MUST COVER constraint. Give an example other than one in this chapter.
6.39 Explain, in general terms, what needs to be done to enforce minimum cardinality.
6.40 Explain the need for each of the actions in Figure 6-28(a).
6.41 Explain the need for each of the actions in Figure 6-28(b).
6.42 State which of the actions in Figure 6-28 must be applied for M-O relationships, O-M
relationships, and M-M relationships.
6.43 Explain what must be done for the DBMS to enforce required parents.
6.44 What design decisions must be made to enforce required parents?
6.45 Explain why the DBMS cannot be used to enforce required children.
6.46 What is a trigger? How can triggers be used to enforce required children?
6.47 Explain why the enforcement of M-M relationships is particularly difficult.
6.48 Explain the need for each of the design decisions in Figure 6-33.
6.49 Explain the implications of each of the minimum cardinality specifications in Figure 6-38.
6.50 Explain the rationale for each of the entries in the table in Figure 6-40.
Project Questions
6.51 Answer Project Question 5.56 if you have not already done so. Design a database for
your model in Project Question 5.56. 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 a required parent, if any, and the form in
Figure 6-28(b) for a required child, if any.
6.52 Answer Project Question 5.57 if you have not already done so. Design a database for
your model in Project Question 5.57(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 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.53 Answer Project Question 5.58 if you have not already done so. Design a database for
your model in Project Question 5.58(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.
6.54 Answer Project Question 5.59 if you have not already done so. Design databases for
your model in Project Question 5.59(a) and for the model in Figure 5-57. Your designs
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 enforcement using referential integrity actions for required
parents, if any, and the form in Figure 6-28(b) for required children, if any.