In this assignment, please examine the data table below and transform it into 3NF. Please address any data quality problem that you note in the data table. For example, look for and eliminate composite attributes, derived attributes and multivalued attributes before creating your 1NF tables.

Imagine the following scenario: The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. The table below shows a portion of this list for the fall semester. As an experienced database designer, you are asked to help the Public Safety office create a better database design in order to eliminate data redundancy.

Question: Describe whether the data table is in 2NF; if it is not in 2NF, transform it into 2NF and include actual data in the 2NF table(s);

Table 1. Parking Tickets STID | LName, FName | PhoneNo! St Lic | L?CNO 38249Brown, Thomas111-7804FL 38249Brown, Thomas 111-7804FL 82453 Green, Sally 82453 Green, Sally 82453 Green, Sally TicketNo Date Code Fine 391-1689 AL 391-1689 AL 391-1689 AL BRY 123 1563409/17/172 BRY 123 16017 TRE 141 14987 TRE 141 16293 TRE-141 17892 09/13/17 09/05/17 09/18/17 09/13/17 $25 $15 $100 $15 $25 3 2