Question: please answer in clear and easy way thank you NORMALISATION EXERCISE 1 InvoiceNum CustID Cust Name Contact Num Sale Staff ID Shoe Model Sale Staff
please answer in clear and easy way
thank you
NORMALISATION EXERCISE 1 InvoiceNum CustID Cust Name Contact Num Sale Staff ID Shoe Model Sale Staff Name Shoe Size ShoeBar Code Price Sale Date Inv1211 1011 Jamie Adams 042 534 245 200121 John Dole S1234-11 UK11 9314286003015 $1,385 01/01/14 Inv3232 1013 Paul McGrath 041 432 456 200123 Paul Citizen S0977-9 UK09 9314286001234 $1,520 03/12/14 Inv3210 1019 Sunil Singh 041 423 124 200121 Johe Dole S1234-12 UK12 9314286003389 $1,385 09/12/14 Inv3225 1011 Jamie Adams 042 534 245 200123 Paul Citizen S0977-11 UK 11 9314286001697 $1.520 12/12/14 Inv2800 1015 Wendy Chen 041 098 733 200155 S0977-8 UK08 9314286003253 $1.520 06/09/14 Margaret Smith Inv3400 1015 Wendy Chen 041 098 733 200123 Paul Citizen S0397-8 UK08 9314286003099 $1.820 22/12/14 The above table is extracted from a spreadsheet of a Handmade Shoe Shop. Each pair of shoes is handmade by a world renowned shoe-maker and has its own individual barcode. Price is based on the shoe model. You are required to: Normalise it and make sure all the resulting tables are in the third normal form (3NF) Create a corresponding Entity-Relationship Diagram (ERD). NORMALISATION EXERCISE 1 InvoiceNum CustID Cust Name Contact Num Sale Staff ID Shoe Model Sale Staff Name Shoe Size ShoeBar Code Price Sale Date Inv1211 1011 Jamie Adams 042 534 245 200121 John Dole S1234-11 UK11 9314286003015 $1,385 01/01/14 Inv3232 1013 Paul McGrath 041 432 456 200123 Paul Citizen S0977-9 UK09 9314286001234 $1,520 03/12/14 Inv3210 1019 Sunil Singh 041 423 124 200121 Johe Dole S1234-12 UK12 9314286003389 $1,385 09/12/14 Inv3225 1011 Jamie Adams 042 534 245 200123 Paul Citizen S0977-11 UK 11 9314286001697 $1.520 12/12/14 Inv2800 1015 Wendy Chen 041 098 733 200155 S0977-8 UK08 9314286003253 $1.520 06/09/14 Margaret Smith Inv3400 1015 Wendy Chen 041 098 733 200123 Paul Citizen S0397-8 UK08 9314286003099 $1.820 22/12/14 The above table is extracted from a spreadsheet of a Handmade Shoe Shop. Each pair of shoes is handmade by a world renowned shoe-maker and has its own individual barcode. Price is based on the shoe model. You are required to: Normalise it and make sure all the resulting tables are in the third normal form (3NF) Create a corresponding Entity-Relationship Diagram (ERD)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
