Question 2 The following questions will be based on the table given below: Title Autho Author ISBN Subject Page r No Nam
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Question 2 The following questions will be based on the table given below: Title Autho Author ISBN Subject Page r No Nam
Question 2 The following questions will be based on the table given below: Title Autho Author ISBN Subject Page r No Name Hello Cup A1000 Hanum 67231 Cakes 867 Cake Razana Hello Cup A1001 Cake! Fresh Food Fresh Food A1000 Hanum 67232 Pasta A1001 Razana 300 Review Review No Name R0001 R0002 Rina a) What normal form is the table in? Give your reasons b) Identify the primary key for the table (2 marks) c) Identify all the functional dependencies within the table (4 marks) d) Normalize the table into 3NF. Show all your work (6 marks) Ali (2 marks) Review A great book Easy to learn