Car Service Normalization Homework Answer

pages Pages: 4word Words: 890

Question :

Normalization Exercise:

Assignment Objectives:

On successful completion of the Computer Assignment, students will demonstrate the ability to:

  1. Consolidate the knowledge gained in doing the practical exercises using Microsoft Access during the semester.
  2. Link the database concepts acquired from the lectures/homework to the practical exercises using Microsoft Access in the Computer Lab.
  3. Normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Weighting, Availability and Due date of the Assignment

  1. The assignment is to normalise a spreadsheet of data into tables in the third normal form(3NF). It is worth 10% of the overall marks for the unit.
  2. Details of the assignment and the required data files are available from the Unit vuws site. 3.The assignment due date is below:

Your job is to normalize the data below from 0NF to 3NF 



CarRego
Manufacturer ID
Manufacturer Name
Service Date
Car Model
Serviced BranchID
Serviced BranchName


MechanicID


Mechanic Name


ServiceID


Type of Service


C1WE23


M1


Holden


3/5/18


Barina


Branch1


Newtown


M1


Harry Potter


S1
Changed exhaust
C1WE23
M1
Holden
3/9/18
Barina
Branch1
Newtown
M1
Harry Potter
S2
Yearly service
C1WE23
M1
Holden
3/9/19
Barina
Branch1
Newtown
M3
Ronald Weasley
S2
Yearly service


G3DEW1


M2


Toyota


3/5/18


Corolla


Branch1


Newtown


M2
Hermoine
Granger


S3
Fuel tank
service


G3DEW1


M2


Toyota


4/6/18


Corolla


Branch2


Haberfield


M2
Hermoine
Granger


S1
Changed
exhaust
PWE23G
M3
Audi
2/3/18
C5
Branch3
Marsfield
M1
Harry Potter
S4
Oil check
PWE23G
M3
Audi
3/9/18
C5
Branch4
Epping
M3
Ronald Weasley
S2
Yearly service
D96EWQ
M1
Holden
8/9/18
Barina
Branch4
Epping
M3
Ronald Weasley
S4
Oil check


Show More

Answer :

3NF Normalization


3NF Normalization

Car Service Normalization