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.The assignment due date is below: Your job is to normalize the data below from 0NF to 3NF You must show your working out to get the marks.

Manufacturer Manufacturer Service ID Name Date Car Model Serviced Serviced BranchID BranchName MechanicID Mechanic Name CarRego M1 C1WE23 C1wE23 C1WE23 M1 Holden Holden Holden 3/5/18 Barina 3/9/18 Barina 3/9/19 Barina Branch1 Branch1 Branch1 Newtown Newtown Newtown M1 M1 M3 M1 ServicelD Type of Service Changed S1 exhaust S2 Yearly service S2 Yearly service Fuel tank S3 service Changed S1 exhaust S4 Oil check S2 Yearly service S4 Oil check G3DEW1 M2 Toyota 3/5/18 Corolla Branch1 Newtown Harry Potter Harry Potter Ronald Weasley Hermoine Granger Hermoine Granger Harry Potter Ronald Weasley Ronald Weasley M2 Toyota Audi G3DEW1 M2 PWE23GM3 PWE23G M3 D96EWQM1 4/6/18 Corolla 2/3/18 C5 3/9/18 C5 8/9/18 Barina Branch2 Branch3 Branch4 Branch4 Haberfield Marsfield Epping Epping M2 M1 M3 M3 Audi Holden Manufacturer Manufacturer Service ID Name Date Car Model Serviced Serviced BranchID BranchName MechanicID Mechanic Name CarRego M1 C1WE23 C1wE23 C1WE23 M1 Holden Holden Holden 3/5/18 Barina 3/9/18 Barina 3/9/19 Barina Branch1 Branch1 Branch1 Newtown Newtown Newtown M1 M1 M3 M1 ServicelD Type of Service Changed S1 exhaust S2 Yearly service S2 Yearly service Fuel tank S3 service Changed S1 exhaust S4 Oil check S2 Yearly service S4 Oil check G3DEW1 M2 Toyota 3/5/18 Corolla Branch1 Newtown Harry Potter Harry Potter Ronald Weasley Hermoine Granger Hermoine Granger Harry Potter Ronald Weasley Ronald Weasley M2 Toyota Audi G3DEW1 M2 PWE23GM3 PWE23G M3 D96EWQM1 4/6/18 Corolla 2/3/18 C5 3/9/18 C5 8/9/18 Barina Branch2 Branch3 Branch4 Branch4 Haberfield Marsfield Epping Epping M2 M1 M3 M3 Audi Holden