For this attached complete the following:

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

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. - 50 points

Table 5-6 Parking Tickets at Millennium College PARKING LICKEI TADLE Coce Fine $25 $15 $100 $15 $25 Ticket# Date Phone-No 111-7804 St-lic FL Lic No LName ETOHIm FName Thomas BRY 123 15634 1017/08 2 16017 11/13/08 1 TRE 141 1498710/05/08 3 16293 11/18/08 I 17892 12/13/082 38249 2453 Green Sally 391-1689 AL