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 youplease answer in clear and easy way thank you NORMALISATION EXERCISE 1

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f