Consider the schema R = (S T U V) and the dependencies S→T, T→U, U→V and V→S.…
GATE · 1999 · CS · Question 2 subparts
Consider the schema R = (S T U V) and the dependencies S→T, T→U, U→V and V→S. Let R (R₁ and R₂) be a decomposition such that R₁∩R₂ ≠ ∅. The decomposition is:
- A.
Not in 2NF
- B.
In 2NF but not in 3NF
- C.
In 3NF but not in 2NF
- D.
In both 2NF and 3NF
Attempted by 354 students.
Sign up free to check your answer
Sign up freeLoading lesson…