. For Assignment 3 you are going to create a data model and will use the E - R Crows F oot Model using Microsoft Visio ( you will have gotten this from the Azure Dev tools site that is discussed in news ). This assignment is using the Writers patrol case questio n which is in Chapter 5 .

Look at the traffic citation in the image below (page 2). As indicated , the rounded corners of the citation provide graphical hints about the boundaries of the entities represented.

Draw the E - R data model based on the traffic ci tation form with five entities. Use the data items on the form to specify identifiers and attributes for those entities. Specify relationships among the entities and name the relationship and give its type and cardinalities.

Note that all Correction Notic es have, as their identifier, an identifying number that is not shown in the figure, and have an independent existence whether or not they are filled in. The alternative would be a composite identifier (such as Month, Date, Year, Time). But this is so cumb ersome that even without a preexisting NoticeNumber wed use a surrogate identifier.

For the assignment we can assume that:

Only one DRIVER is cited because there is only room for one set of DRIVER information. Logically, however, one DRIVER may receive more than one CORRECTION_NOTICE.

Only one OFFICER issues the CORRECTION_NOTICE because there is only one OFFICER Signature. Logically, however, one OFFICER may issue many CORRECTION_NOTICES.

Only one VEHICLE is recorded because there is only room for one set of VEHICLE information. Logically, however, one VEHICLE may be subject to more than one CORRECTION_NOTICE.

A CORRECTION_NOTICE can have several VIOLATIONs because of the multiple lines and the wording Violations (plural). However, each VIO LATION is associated with the CORRECTION_NOTICE it is listed on.

We also can assume:

The logic that one DRIVER may receive more than one CORRECTION_NOTICE.

The logic that one OFFICER may issue many CORRECTION_NOTICES.

The logic that one VEHICLE may be subject to more than one CORRECTION_NOTICE.

The cardinality of RegisteredOwner on VEHICLE. For example, the RegisteredOwner could be John and Mary Smith.

Create an ER model in ERDPlus for the following information mentioned in the Traffic Citation. You need to identify the entity names and attributes from this citation. You can assume some attributes even if these attributes are not mentioned in this citation. WASHINGTON STATE PATROL CORRECTION NOTICE NAME LAST FIRST ADDRESS ZIP Kroenke David M 5053 88 Ave SE CITY Mecer Island 00000 Walf 2/2746 6 165BV AAA000 wa 99 saab 900 STATE Wa CODE 98040 DRIVERS LICENSE STATE BIRTH DATE HGT WGT EYES VEHICLES LICENSE STATE COLOR YEAR MAKE TYPE VIN REGISTERED OWNER ADDRESS VIOLATION DATE LOCATION MO 11 DAY 7 You 2012. 935 2 The E Enumckum SR410 Writing text while driving 17 MILES OF ON VIOLATIONS OFFICERS SIGNATURE PERSONNEL NUMBER S Scott 850 This is a waming, no further action is required. You are roloasod to take this vehiclo to a place of repair. Continuod operation on the roadway is not authorized CORRECT VIOLATION(S) IMMEDIATELY. Roturn this signed card for pmof of compliance within 1/30 days. (if this box chocked) DRIVERS SIGNATURE Create an ER model in ERDPlus for the following information mentioned in the Traffic Citation. You need to identify the entity names and attributes from this citation. You can assume some attributes even if these attributes are not mentioned in this citation. WASHINGTON STATE PATROL CORRECTION NOTICE NAME LAST FIRST ADDRESS ZIP Kroenke David M 5053 88 Ave SE CITY Mecer Island 00000 Walf 2/2746 6 165BV AAA000 wa 99 saab 900 STATE Wa CODE 98040 DRIVERS LICENSE STATE BIRTH DATE HGT WGT EYES VEHICLES LICENSE STATE COLOR YEAR MAKE TYPE VIN REGISTERED OWNER ADDRESS VIOLATION DATE LOCATION MO 11 DAY 7 You 2012. 935 2 The E Enumckum SR410 Writing text while driving 17 MILES OF ON VIOLATIONS OFFICERS SIGNATURE PERSONNEL NUMBER S Scott 850 This is a waming, no further action is required. You are roloasod to take this vehiclo to a place of repair. Continuod operation on the roadway is not authorized CORRECT VIOLATION(S) IMMEDIATELY. Roturn this signed card for pmof of compliance within 1/30 days. (if this box chocked) DRIVERS SIGNATURE