Design a database for your model. 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 enforcement using referential integrity actions for required parents, if any, and the form in Figure6-28(b) for required children, if any.

In Question 5.59, Consider the traffic citation shown in Figure 5-54. The rounded corners on this form provide graphical hints about the boundaries of the entities represented.

A. Create a data model with five entities. Use the data items on the form to specify identifiers and attributes for those entities.

B. Specify relationships among the entities. Name the relationship and give its type and cardinalities. Indicate which cardinalities can be inferred from data on the form and which need to be checked out with systems users.