vCustI D CustPhone CustName CustAddr ProdCod e ProdNam e ProdPric e ManufI D ManufNam e 2014 6129685987 8 Bob the Builder Beaumoun t Hills GT1500 Treated Pine Gate $74.25 V123 Timberland 2014 6129685987 8 Bob the Builder Beaumoun t Hills QSC100 Quik Set Cement $7.70 V833 Bastion 3752 6129876543 2 Joe Handyma n Rouse Hill QSC100 Quik Set Cement $7.70 V833 Bastion 2014 6129685987 8 Bob the Builder Beaumoun t Hills DAR88 Wrapped Posts $40.10 V511 Kaituna 8125 6129685169 2 John Roofman Northmead QSC100 Quik Set Cement $7.70 V833 Bastion 8125 6129685169 2 John Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop # ShopLocation ShopPhone QtyAvail QtySold Sales# SalesDate StaffID StaffName 15 Castle Hill 61296394567 55 2 S1325 13/05/2017 164 James Bond 15 Castle Hill 61296394567 1478 2 S1325 13/05/2017 164 James Bond 15 Castle Hill 61296394567 1476 2 S1330 13/05/2017 164 James Bond 15 Castle Hill 61296394567 231 15 S1012 20/03/2017 130 Tom Cruise 22 Parramatta 61296859678 350 4 S7651 10/04/2017 762 Russell Crowe 22 Parramatta 61296859678 54 2 S7651 10/04/2017 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 companys 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