Normalisation Exercise (Hardware Store) Cunnings Hardware House is a retail chain selling building tools and supplies for tradespeople and handy people. It operates in many locations in Sydney. The following is extracted from the company's spreadsheet to show the relationships among different data fields. You are employed to develop a relational database system by normalising the spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process You are required: a) Normalise the below spreadsheet to tables in the third normal form (3NF). Specify the primary key and foreign key (if any) for each resulting table (8 marks). b) Develop an Entity-Relationship Diagram from the resulting tables in (a) (12 marks) | CustID CustPhone CustName CustAddr ProdCode ProdName ProdPrice ManufID ManufName | Bob the Beaumount Treated 2014 61296859878 Builder Hills GT1500 Pine Gate $74.25 V123 Timberland Bob the Beaumount Quik Set 2014 61296859878 Builder Hills QSC100 Cement $7.70 V833 Bastion Joe Quik Set 3752 61298765432 Handyman Rouse Hill QSC100 Cement $7.70 V833 Bastion Bob the Beaumount Wrapped 2014 61296859878 Builder Hills DAR88 Posts $40.10 V511 Kaituna John Quik Set 812561296851692 Roofman Northmead QSC100 Cement $7.70 V833 Bastion John 812561296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop Shop Location 15 Castle Hill 15 Castle Hill 15 Castle Hill 15 Castle Hill 22 Parramatta 22 Parramatta ShopPhone 61296394567 61296394567 61296394567 61296394567 61296859678 61296859678 Qty Avail 55 1478 1476 231 350 54 QtySold Sales# SalesDate 2 S1325 13/05/2017 2 51325 13/05/2017 251330 13/05/2017 15 S1012 | 20/03/2017 S7651 10/04/2017 2 S7651 10/04/2017 StaffiD StaffName 164 James Bond 164 James Bond 164 James Bond 130 Tom Cruise 762 Russell Crowe 762 Russell Crowe Normalisation Exercise (Hardware Store) Cunnings Hardware House is a retail chain selling building tools and supplies for tradespeople and handy people. It operates in many locations in Sydney. The following is extracted from the company's spreadsheet to show the relationships among different data fields. You are employed to develop a relational database system by normalising the spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process You are required: a) Normalise the below spreadsheet to tables in the third normal form (3NF). Specify the primary key and foreign key (if any) for each resulting table (8 marks). b) Develop an Entity-Relationship Diagram from the resulting tables in (a) (12 marks) | CustID CustPhone CustName CustAddr ProdCode ProdName ProdPrice ManufID ManufName | Bob the Beaumount Treated 2014 61296859878 Builder Hills GT1500 Pine Gate $74.25 V123 Timberland Bob the Beaumount Quik Set 2014 61296859878 Builder Hills QSC100 Cement $7.70 V833 Bastion Joe Quik Set 3752 61298765432 Handyman Rouse Hill QSC100 Cement $7.70 V833 Bastion Bob the Beaumount Wrapped 2014 61296859878 Builder Hills DAR88 Posts $40.10 V511 Kaituna John Quik Set 812561296851692 Roofman Northmead QSC100 Cement $7.70 V833 Bastion John 812561296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop Shop Location 15 Castle Hill 15 Castle Hill 15 Castle Hill 15 Castle Hill 22 Parramatta 22 Parramatta ShopPhone 61296394567 61296394567 61296394567 61296394567 61296859678 61296859678 Qty Avail 55 1478 1476 231 350 54 QtySold Sales# SalesDate 2 S1325 13/05/2017 2 51325 13/05/2017 251330 13/05/2017 15 S1012 | 20/03/2017 S7651 10/04/2017 2 S7651 10/04/2017 StaffiD StaffName 164 James Bond 164 James Bond 164 James Bond 130 Tom Cruise 762 Russell Crowe 762 Russell Crowe