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
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