Each police officer may issue speeding tickets to motorists in an assigned area. Originally, the attribute date was modeled as part of the SPEEDING TICKET entity. However, the city police department wants to see if there is a relationship between weather and the frequency of speeding tickets -- do people drive faster on nice sunny days? Are there more tickets in hot weather or cool weather?
Modify the ERD to address this new requirement.

Please see attached copy

 

 

 

Complete the following quesTons in an MS Word document format only. Save the Fnal Fle in the formatof "Week 6 Wri±en Homework_Your²ullNameHere.doc". ³urn it into Digital Drop Box (Don't use emaila±achment or copy and paste into Drop box)1. Speeding ³icketsEach police o´cer may issue speeding Tckets to motorists in an assigned area. Originally, the a±ributedate was modeled as part of the SPEEDING ³ICKE³ enTty. However, the city police department wants tosee if there is a relaTonship between weather and the frequency of speeding Tckets -- do people drivefaster on nice sunny days? Are there more Tckets in hot weather or cool weather?Modify the ERD to address this new requirement.2. Comic-book collectors need to know the price history of diµerent types of comics. ³his helps themdecide what to purchase/collect and how much to sell their collecTon for.Create an ERD (two or three enTTes) to model this.

Attachments:

• 1496737580-help 1.docx