ITM$520$: Project $3$

WRITER'S PATROL CASE STUDY

Consider the Writer's Patrol traffic citation shown in Figure $4-28.$

Draw an E$-$R data model based on the traffic citation form. Use five entities, create identifiers and use the

data items on the form to specify attributes for the entities. Use the IE Crow's Foot E$-$R model for your E$-$R

diagram.

FIGURE $4-28$

Writer's Patrol Traffic

Citation

WRITER'S PATROL CORRECTION NOTICE

A$.$ Specify relationships among the entities. Name the relationships, and specify the relationship

types and cardinalities. Justify the decisions you make regarding minimum and maximum

cardinalities, indicating which cardinalities can be inferred from the data on the form and which

need to be checked out with the system users.