1. Convert this table to a relation in first normal form by entering appropriate data (hand write or type this)

2. Now take this table from number 1 and normalize it to 3NF. Also add a new column called Violation that explains the type of violation mapped to the Code shown on the attached table: Parking Ticket (code 1), No Parking Permit (code 2), Handicap Violation (code 3). You MUST show all of your work.

Table 5-6 Parking Tickets at Millennium College PARKING TICKET TABLE S IDL CodeFine Ticket# Date 15634 16017 14987 10/05/083 16293 17892 L Nm FName Phone_No StLic Thomas 111-7804 Lic No BRY 123 10/17/08 11/13/08 $25 $15 $100 $15 $25 FL 38249 Brown 82453 Green Sally 391-1689 AL TRE 141 11/18/08 12/13/08 2