No More Smelly Shoes is a large manufacturer of children’s school and sports shoes. The organisation runs a file system. The following is an extract of its sales file.

Required

(a) Normalise this table to third normal form. Show all forms.

(b) Discuss any assumptions you have made in normalising the table.

(c) Illustrate your normalisation by providing an entity-relationship (E-R) diagram.

Transcribed Image Text:

Customer_name Britney Considine Customer_address Customer_phone Salesperson Shoe_model Shoe_amount Date 2 Apple Street, Melbourne, VIC 03 1234 5678 TLM VZ4717 $29.90 20-Jul-08 Michelle Lee 6 Organic Street, 03 9876 4321 CBD DF3966 $79.50 30-Jul-08 Melbourne, VIC Phillipa Collier 8 Grapefruit Street, 03 5678 3456 Melbourne, VIC MTL WE9447 $50.30 4-Aug-08 Devine Smith 3 Echo Street, 03 2376 1048 JFK XC8187 $45.50 6-Oct-08 Melbourne, VIC