(Solved) : Normalisation Exercise Hardware Store Cunnings Hardware House Retail Chain Selling Buildin Q41374349 . . .

Normalisation Exercise (Hardware Store) Cunnings Hardware House is a retail chain selling building tools and supplies for trab) Develop an Entity-Relationship Dlagram from the resulting tables in (a) (12 marks) daunu CustID CustPhone CustName CustAddNormalisation 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 Dlagram from the resulting tables in (a) (12 marks) CustName CustAddr Bob the CustID CustPhone ProdCode Prodame ProdPrice ManufID ManufName Beaumount Treated 2014 61296859878 Builder GT1500 Pine Gate $74.25 V123 Timberland Bob the Beaumount Hills Quik Set 2014 61296859878 Builder QSc100 Cement $7.70 V833 Bastion Joe Quik Set Cement Wrapped 3752 61298765432 Handyman Rouse Hill QSC100 $7.70 V833 Bastion Bob the Beaumount 2014 61296859878 Builder John 8125 61296851692 Roofman DAR88 Posts $40.10 V511 Kaituna Quik Set Northmead QSC100 Cement $7.70 V833 Bastion John 8125 61296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion b) Develop an Entity-Relationship Dlagram from the resulting tables in (a) (12 marks) daunu CustID CustPhone CustName CustAddr ProdCode ProdName ProdPrice ManufiD ManufName Bob the Beaumount Treated GT1500 $74.25 V123 Timberland 2014 61296859878 Builder Bob the 2014 61296859878 Builder Pine Gate Quik Set Cement 0013SO Beaumount $7.70 V833 Bastion nnnnneonpno Joe Quik Set $7.70 V833 Bastion 3752 61298765432 Handyman Rouse Hill Bob the 00OSO Wrapped Cement Beaumount $40.10 V511 Kaituna 2014 61296859878 Builder John 8125 61296851692 Roofman DAR88 Quik Set Cement Northmead QSC100 $7.70 V833 Bastion John 8125 61296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop# ShopLocation ShopPhone 61296394567 QtyAvail QtySold Sales# SalesDate StaffID StaffName 55 13/05/2017 13/05/2017 13/05/2017 20/03/2017 10/04/2017 10/04/2017 15 Castle Hill 2 S1325 164 James Bond 15 Castle Hill 61296394567 1478 2 S1325 164 James Bond 164 James Bond 15 Castle Hill 61296394567 1476 2 S1330 15 Castle Hill 61296394567 231 15 S1012 22 Parramatta 22 Parramatta 130 Tom Cruise 762 Russell Crowe 762 Russell Crowe 61296859678 350 4 57651 61296859678 2 S7651 Show transcribed image text 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 Dlagram from the resulting tables in (a) (12 marks) CustName CustAddr Bob the CustID CustPhone ProdCode Prodame ProdPrice ManufID ManufName Beaumount Treated 2014 61296859878 Builder GT1500 Pine Gate $74.25 V123 Timberland Bob the Beaumount Hills Quik Set 2014 61296859878 Builder QSc100 Cement $7.70 V833 Bastion Joe Quik Set Cement Wrapped 3752 61298765432 Handyman Rouse Hill QSC100 $7.70 V833 Bastion Bob the Beaumount 2014 61296859878 Builder John 8125 61296851692 Roofman DAR88 Posts $40.10 V511 Kaituna Quik Set Northmead QSC100 Cement $7.70 V833 Bastion John 8125 61296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion
b) Develop an Entity-Relationship Dlagram from the resulting tables in (a) (12 marks) daunu CustID CustPhone CustName CustAddr ProdCode ProdName ProdPrice ManufiD ManufName Bob the Beaumount Treated GT1500 $74.25 V123 Timberland 2014 61296859878 Builder Bob the 2014 61296859878 Builder Pine Gate Quik Set Cement 0013SO Beaumount $7.70 V833 Bastion nnnnneonpno Joe Quik Set $7.70 V833 Bastion 3752 61298765432 Handyman Rouse Hill Bob the 00OSO Wrapped Cement Beaumount $40.10 V511 Kaituna 2014 61296859878 Builder John 8125 61296851692 Roofman DAR88 Quik Set Cement Northmead QSC100 $7.70 V833 Bastion John 8125 61296851692 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop# ShopLocation ShopPhone 61296394567 QtyAvail QtySold Sales# SalesDate StaffID StaffName 55 13/05/2017 13/05/2017 13/05/2017 20/03/2017 10/04/2017 10/04/2017 15 Castle Hill 2 S1325 164 James Bond 15 Castle Hill 61296394567 1478 2 S1325 164 James Bond 164 James Bond 15 Castle Hill 61296394567 1476 2 S1330 15 Castle Hill 61296394567 231 15 S1012 22 Parramatta 22 Parramatta 130 Tom Cruise 762 Russell Crowe 762 Russell Crowe 61296859678 350 4 57651 61296859678 2 S7651

Expert Answer


Answer to Normalisation Exercise (Hardware Store) Cunnings Hardware House is a retail chain selling building tools and supplies fo…