Option #1: Washington State Patrol Case Questions
Consider the traffic citation shown in the figure below. The rounded corners on this form provide graphical hints about the boundaries of the entities represented.
- Create the entities for an ERD model based on the traffic citation form. Use five entities and use the data items on the form to specify identifiers and attributes for those entities. In which of these entities should you place the unique Notice Number that is the unique identifier for this notice?
- Complete the ERD model by specifying relationships among the entities. Name the relationships and specify the relationship types and cardinalities (i.e. one-to-one, one-to-many, or many-to-many. Justify the decisions you make regarding minimum and maximum cardinalities, indicating which cardinalities can be inferred from data on the form and which need to be checked out with systems users. 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.
- Submit your deliverable in a Word document. You can use Visio or Lucid-chart to create the Entity-Relationship Diagram.