Programming
October 10, 2023DatabaseManagementSystem
October 10, 2023DatabaseManagementSystem
Question 29

Consider the schema R = (S T U V) and the dependencies S → T, T → U, U → V and V → S. Let R = (R1 and R2) be a decomposition such that R1 ∩ R2 ≠ ∅ . The decomposition is
not in 2NF


in 2NF but not 3NF


in 3NF but not in 2NF


in both 2NF and 3NF

Question 29 Explanation:
Since R1 ∩ R2 ≠ ∅, so the decomposition is lossless join. Now since all the attributes are keys, so R1 ∩ R2 will be a key of the decomposed relation.
And since every attribute is key so the decomposed relation will be in BCNF and hence in 3NF.
And since every attribute is key so the decomposed relation will be in BCNF and hence in 3NF.
Correct Answer: D
Question 29 Explanation:
Since R1 ∩ R2 ≠ ∅, so the decomposition is lossless join. Now since all the attributes are keys, so R1 ∩ R2 will be a key of the decomposed relation.
And since every attribute is key so the decomposed relation will be in BCNF and hence in 3NF.
And since every attribute is key so the decomposed relation will be in BCNF and hence in 3NF.
Subscribe
Login
0 Comments