SUBJECT : DATABSE DESIGN AND DEVELOPMENT

Member Name Table 1.0: Company's Dinner Club Address Dinner Dinner Venue Venue ID Date Code Description 4, Privet D001 15 Jan B01 Grand Ball Drive, Little 2021 Room Whinging Food Code EN3 214 Food Description Stuffed crab Uchiha Madara DES Chocolate mousse Marinated steak 235 DO02 Haruno Sakura BO2 ENS 15 Jan 2021 Petit Ball Room 1 12 Grimmauld Place, Burrow DE8 Chocolate mousse Pumpkin soup 250 D003 C01 Cafe S01 Uchiha Sasuke 12, Picket Post Close Winkfield 20 Mar 2021 EN5 DE2 S01 Marinated steak Apple pie Pumpkin soup 235 D003 C01 Cafe Haruno Sakura 20 Mar 2021 12 Grimmauld Place, Burrow EN5 DE2 SA2 Marinated steak Apple pie Caesar salad 300 D004 E10 20 Mar 2021 Petit Ball Room 10 Hatake 934, Kakashi King's Cross, Hogwarts Based on table 1.0, answer the following questions: a) State the normal form of the table 1. Give ONE (1) reason for your answer. (3 marks) b) What would happen to the company's database, if the manager does not fix the problem based on your reason in (a)? (3 marks) c) Normalize the table into 3NF. Show each step in the normalization process. The primary key(s), partial dependencies and/or transitive dependencies need to be clearly identified. (14 marks)