bart NORMALISATION EXERCISE 1 ShoeModel ShoeSize ShoeBar Code Price Sale Date InvoiceNum| CustID Cust Name Contact Num SaleStaff ID Sale Staff Name 9314286003015 $1,385 01/01/14 Inv1211 1011 Jamie Adams 042 534 245 200121 John Dole 51234-11 UK11 Inv3232 1013 Paul McGrath 041 432 456 200123 Paul Citizen 50977-9 UK09 9314286001234 $1,520 03/12/14 Inv3210 1019 Sunil Singh 041 423 124 200121 Johe Dole 51234-12 UK12 9314286003389 $1,385 09/12/14 Inv3225 1011 Jamie Adams 042 534 245 200123 Paul Citizen 50977-11 UK11 9314286001697 $1,520 12/12/14 Inv2800 1015 Wendy Chen 041 098 733 200155 Margaret 50977-8 UKOB 9314286003253 $1,520 06/09/14 Smith Inv3400 1015 Wendy Chen 041 098 733 200123 Paul Citizen 50397-8 UKOB 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)