Question: Question : We have a relational model represented as a relational schema and its functional dependencies given as below: Assignments(A, B, C, D, E, F,
Question : We have a relational model represented as a relational schema and its functional dependencies given as below:
Assignments(A, B, C, D, E, F, G, H, I, J, K, L, M, O)
fd1: A, B, C -> D, E, F, G, H, I, J, K, L, M, O
fd2: A -> D, E, F, L, M, O
fd3: B, C -> G, H
fd4: D -> L, M, O
fd5: L -> M
fd6: G -> H
- Is this relational model in 1NF? Why? If not, normalize it to 1NF. Make sure you list ALL relations after the normalization process; and for each relation, list the functional dependencies.
- Is this relational model in 2NF? Why? If not, normalize it to 2NF. Make sure you list ALL relations after the normalization process; and for each relation, list the functional dependencies.
- Is the relational model in 3NF? Why? If not, normalize it to 3NF. Make sure you list ALL relations after the normalization process; and for each relation, list the functional dependencies.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
