Normalise this in 3NF and draw ERD diagram Custl ProdCod ProdNam ProdPric D CustPhone CustName CustAddr e

Normalise this in 3NF and draw ERD diagram

 

Transcribed Image Text:

Custl ProdCod ProdNam ProdPric D CustPhone CustName CustAddr e e e Manufl D ManufNam e 6129685987 Bob the Beaumoun Treated 2014 8 Builder t Hills GT1500 Pine Gate $74.25 V123 Timberland 6129685987 Bob the Beaumoun Quik Set 2014 8 Builder t Hills QSC100 Cement $7.70 V833 Bastion Joe 6129876543 Handyma Quik Set 3752 2 n Rouse Hill QSC100 Cement $7.70 V833 Bastion 6129685987 Bob the 2014 8 Builder Beaumoun t Hills Wrapped DAR88 Posts $40.10 V511 Kaituna 6129685169 John 8125 2 Roofman Northmead QSC100 Quik Set Cement $7.70 V833 Bastion 6129685169 John 8125 2 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop # ShopLocation 15 Castle Hill 15 Castle Hill ShopPhone 61296394567 61296394567 Qty Avail QtySold 55 1478 Sales# SalesDate StaffID StaffName 2 2 S1325 S1325 13/05/2017 164 James Bond 13/05/2017 164 James Bond Custl ProdCod ProdNam ProdPric D CustPhone CustName CustAddr e e e Manufl D ManufNam e 6129685987 Bob the Beaumoun Treated 2014 8 Builder t Hills GT1500 Pine Gate $74.25 V123 Timberland 6129685987 Bob the Beaumoun Quik Set 2014 8 Builder t Hills QSC100 Cement $7.70 V833 Bastion Joe 6129876543 Handyma Quik Set 3752 2 n Rouse Hill QSC100 Cement $7.70 V833 Bastion 6129685987 Bob the 2014 8 Builder Beaumoun t Hills Wrapped DAR88 Posts $40.10 V511 Kaituna 6129685169 John 8125 2 Roofman Northmead QSC100 Quik Set Cement $7.70 V833 Bastion 6129685169 John 8125 2 Roofman Northmead RV300 Roof Vent $69.00 V833 Bastion Shop # ShopLocation 15 Castle Hill 15 Castle Hill ShopPhone 61296394567 61296394567 Qty Avail QtySold 55 1478 Sales# SalesDate StaffID StaffName 2 2 S1325 S1325 13/05/2017 164 James Bond 13/05/2017 164 James Bond