e OFF *** Normalization problem i... -Saved to my Mac Insert Draw Design Layout >> Tell me Comments Editing G A A G Font Paragraph Styles Dictate Sensitivity Editor Open Grammarly te Available We've made some fixes and improvements. To complete the process, th... The Campus Safety office at CLU maintains a list of parking tickets issued to vehicles parked illegally on campus. The table below shows a portion of this list. Restart N Student Last First Phone ID Name Name No State Plate Plate No 38248 Brown Thomas 805-455- 7804 CA BRY 123 Ticket Date No 15634 Violation Fine Code 10/17/ 2 $50 Violation Description Parked in S lot w/o 18 permit 38249 Jackson Thomas 805-455- 7805 CA SAT 123 16017 9/13/18 1 $125 Parking permit not 82452 Green Sally 805-455- CA |3 7806 TRR141 14987 10/05/18 3 $100 displayed Parked more than 18" from curb 82453 Long Mary 805-455- CA 7807 BFG 141 16293 9/18/18 1 $125 Parking permit not displayed Parked in S 82455 Johnson Roxanne 805-455- 7808 CA YGH 141 17892 10/1/18 2 $50 lot w/o permit Questions: What are the determinants in this relation? Draw all functional dependencies in this relation. What normal form is this relation in? Give an example of at least 2 anomalies that can result in this relation. Normalize the relation above to third normal form relations and develop the complete relational schema (indicate all PKS, FKs and referential integrity). Please note the following business rules: a. Each ticket is given for a single offense at the time (so that they can be paid and/or disputed separately). For example, if John Smith had 2 different violations during the same encounter with the parking officers, the officer will write 2 separate tickets for John Smith during that encounter and place them on the windshield. Thus, John Smith may get 2 separate tickets during the same encounter, e.g. (a) one for parking in lot S without permit and (b) another ticket for an expired registration. b. Each offense has a description and associated fine. C. Each ticket (e.g. ticket AHDIH834421) can be traced back to an individual student. Page 1 of 1 SC 305 words Focus + 116%