Please complete the Test 2 Part 1 quiz.  Then open the attached document that shows a table of Parking Tickets at Millennium College.

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