Analyse & normalize the above data to 3NF, create any entities (including implied entities) and draw a low-level ER diagram showing all entities, attributes, keys and foreign keys (these must be clearly marked). NOTE: You do need to show your Normalization steps but only the final E-R model.

data Consider the following flat file database:

cust-id name address product-id desc quantity price order-id order-date 12 Mr Joe Bloggs 5 Muller Rd .. 75 widget 7 14.00 34 01/3/10 12 Mr Joe Bloggs 5 Muller Rd .. 12 nibbet 3 9.00 34 01/3/10 13 Mr Harry Hill 43 Dry Av.. 75 widget 4 8.00 36 01/03/10 13 Mr Harry Hill 43 Dry Av.. 23 gibbet 2 3.50 36 01/03/10 14 Ms Jean Grey 34 Tree Hill 12 nibbet 5 12.50 43 03/03/10