Question 1: (40 points) The Traffic Police keeps records of all the speed violations recorded by the radars on all roads

[answerhappygod]

Question 1 40 Points The Traffic Police Keeps Records Of All The Speed Violations Recorded By The Radars On All Roads 1 (55.02 KiB) Viewed 19 times

Question 1: (40 points) The Traffic Police keeps records of all the speed violations recorded by the radars on all roads. Data is saved in a spreadsheet with the following columns: - Timestamp: The date and time, the violation was recorded - Car Plate Number - Owner: Name of the owner of the car - TelNo: Phone number of the owner - Radar No: The radar that recorded the violation - Location: the location of violation - Speed: The speed committing violation - Penalty: The amount of penalty to be paid, it is derived from the speed using some formula Note that an owner can own more than one car and can make any number of violations. a) Find the functional dependencies in the structure above. b) Decompose into tables to create the physical design. c) Verify the normal form of each table and change into 3NF when it is not.