Question: need help on this Part 3 - Normalization [20 marks total] Case 1: The table R (A, B, C, D, E, F, G, H, Y)

need help on this

Part 3 - Normalization [20 marks total] Case 1: The table R (A, B, C, D, E, F, G, H, Y) holds the following functional dependencies: FD1 A, C B, D, E, F, G, H, Y FD2 B H, Y FD3 G E, F Answer the following questions: 1- What is the primary key in the table R? [2 Marks] 2- Name the partial dependencies and the transitive dependencies if they exist in R. [2 Marks] 3- Is the table R in the 1NF or in the 2NF or in 3NF, and why? [2 Marks] 4- Normalize the table up to the 3NF. [2 Marks] 5- Identify the primary and foreign keys in your 3NF relations. [2 Marks] Case 2: The table R (A, B, C, D, E, F, G, H, I, J) holds the following functional dependencies: FD1 A, B, C D, E, F, G, H, I, J FD2 B E FD3 F G FD4 I D Answer the following questions: 1- What is the primary key in the table R? [2 Marks] 2- Name the partial dependencies and the transitive dependencies if they exist in R. [2 Marks] 3- Is the table R in the 1NF or in the 2NF or in 3NF, and why? [2 Marks] 4- Normalize the table up to the 3NF. [2 Marks] 5- Identify the primary and foreign keys in your 3NF relations.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!