Q.
Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then 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
Answer & Explanation
Option: [B]