Determine tables needed to produce the 'traffic citation' shown in FIGURE 4-22.

When typing out the fields names in each table, underline (mark) the primary key field

Draw the Crow's Feet symbols if possible to the field names which would connect (join) the tables.

Submit answers in a MS Word file including a hand-drawn E-R model (take a picture & insert in MS Word)

WRITER'S PATROL CASE QUESTIONS Consider the Writer's Patrol traffic citation shown in Figure 4-22. The rounded co this form provide visual hints about the boundaries of the entities represented. A. Draw an E-R data model based on the traffic citation form. Use five entities, create identifiers (watch out for any composite identifiers that may be needed, and you can use surrogate identifiers if appropriate), and use the data items on the form to specif attributes for the entities. Use the IE Crow's Foot E-R model for your E-R diagram. FIGURE 4-22 WRITER'S PATROL CORRECTION NOTICE Writer's Patrol Traffic Citation RavidM 5053 88 Ave SE an Mercer Island m Wa Saab 93 17mEEnumckum SR410 Witing text while driving 850