Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

Students also viewed these Databases questions

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago