Question: 1. (10 points) Create a data model (E/R model) for the database based on the information given by the following traffic ticket. The information showing

1. (10 points) Create a data model (E/R model) for the database based on the information given by the following traffic ticket. The information showing in this ticket should be stored in future database. The signitures will also be scaned and stored as digital file. The database will keep the hyperlink to these files. WASHINGTON STATE PATROL CORRECTION NOTICE NAME KYroenke David LAST FIRST 5053 88 Ave SE ADDRESS a Mecer sland STATE DRIVERS LICENSE STATE BIRTH DATEHGTWGT EYES Wa 2/2746 6 165 900 VEHICLES LICENSE 0 STATECOLOR YEAR saab VIN OWNER ADDRESS MOLATION DATE DIST DETACH 7 YEAR 200 935 FEnunckum o SR410 LOCATION MILES MOLATIONS OFFICERS SIGNATURE This is a warning, no further action is required. You are released to take this vohicle to a place of ropair. Continued operation on the roadway is not authorized CORRECT MOLATIONS) IMMEDIATELY. Retum this signod card ithin 15/30 days. (if this box checked) DRIVER SIGNAT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
