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.

Depict the full key, partial and transitive functional dependencies in the data table using the written notation (e.g., ID Name, Address);

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