Question
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
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.
Describe whether the data table is in 3NF; if it is not in 3NF, transform it into 3NF and include actual data in the 3NF 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 2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started