22. The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. The following table shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.) (5%) Parking Ticket Table St ID 38249Brown F Name Phone No St Lic Thomas 784 Sally Lic No Ticket # Date 0/17/2015 11/13/2015 0/05/2015 1/18/2015 2/13/2015 L Name Code Fine BRY 123 15634 16017 14987 16293 17892 FL $25 $15 $100 $15 $25 82453 Green 391-1689 AL TRE 141 i. Convert this table to a relation in first normal form by entering appropriate data in the table. What are the determinants in this relation? ii. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. ii. Give an example of one or more anomalies that can result in using this relation. Develop a set of relations in third normal form. Include a new column with the heading Violation in the appropriate table to explain the reason for each ticket. Values in this column are: expired parking meter (ticket code 1), no parking permit (ticket code 2), and handicap violation (ticket code 3) iv