Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 3 Table 1.0 stores information to assist a manager of a company dinner club to plan meals and a a keep track of who
QUESTION 3 Table 1.0 stores information to assist a manager of a company dinner club to plan meals and a a keep track of who attends the dinners. Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL CS/FEB 2021/CT450/1 TS432 Member ID 214 235 250 Table 1.0: Company's Dinner Club Name Address Dinner Dinner Venue Venue Food Food ID Date Code Description Code Description Uchiha 4, Privet D001 15 Jan B01 Grand Ball EN3 Stuffed Madara Drive, Little 2021 Room crab Whinging DE8 Chocolate mousse Haruno 12. DOO2 15 Jan BOZ Petit Ball ENS Marinated Sakura Grimmauld 2021 Room 1 steak Place Burrow DES Chocolate mousse Uchiha 12, Picket D003 20 Mar 001 Cafe S01 Pumpkin Sasuke Post Close 2021 soup Winkfield ENS Marinated steak DE2 Apple pie Haruno 12 DOO3 20 Mar 001 Cate S01 Pumpkin Sakura Grimmauld 2021 soup Place, Burrow ENS Marinated steak DE2 Apple pie Hatake 934 D004 20 Mar E10 Petit Ball SA2 Caesar Kakashi King's 2021 Room 10 salad Cross Hogwarts 235 235 300 Based on table 1.0, answer the following questions: ) 1) 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) Hak Cinta Ini Teknalni MAR CONFIDENTIAL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started