#doitnow#asap#urgent

Please do show all the work

Below is a table of Parking Tickets at Millennium College. Table 5-6 Parking Tickete ot Millennium College 111-004 39m-1000 A 10017 TRE 141147 82453 Sally eass 1313 7er For this table complete the following: 1. Convert this table to a relation in first normal form by entering appropriate data. - 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