1. Create a data model with 4 entities. Use the data items on the form to specify identifiers and attributes for those entities. Using Crows Foot notation show the relationships and cardinality of the relationships. If there is not enough information on the form to determine the cardinality, then make a list of questions you would need to ask the customer to clarify.

For instance, on the form it looks like there can only be one officer writing the ticket. So Max would be one. But can we conclude that one driver could receive more than one ticket?

Submit your ERD with attached notes to this assignment. You can draw it and scan or use MS Visio or another program to create it.

I have attached one that i did. you can use as a sample

WASHINGTON STATE PATROL CORRECTION NOTICE NAME Kroenke ADORESS 5053 88 Ave SE ay Mecer Island STATE Wa 98040 David M LAST FRST STATE BIRTH DATE HGT WGT EYES War 2/2746 6 1658 VEHICLES UCENSE STATE COLOR EAR TYPE VIN REGISTERED OWNER MOLATION DATE DIST DETACH DAY LOCATION E OrEnumckum on SR410 Writing text while MILES MIOLATIONS OFFICERS SIGNATURE S Scott NUMBER 850 man 1re Conte demces Sch ools School D Plower s Plowes D ast Nane Huht mie him ma C1 state Madiot Nownd Posrhon Yeoe onde WASHINGTON STATE PATROL CORRECTION NOTICE NAME Kroenke ADORESS 5053 88 Ave SE ay Mecer Island STATE Wa 98040 David M LAST FRST STATE BIRTH DATE HGT WGT EYES War 2/2746 6 1658 VEHICLES UCENSE STATE COLOR EAR TYPE VIN REGISTERED OWNER MOLATION DATE DIST DETACH DAY LOCATION E OrEnumckum on SR410 Writing text while MILES MIOLATIONS OFFICERS SIGNATURE S Scott NUMBER 850 man 1re Conte demces Sch ools School D Plower s Plowes D ast Nane Huht mie him ma C1 state Madiot Nownd Posrhon Yeoe onde