Consider the schema R = (S T U V) and the dependencies S → T, T → U, U → V and…

PYQ RPSC Programmer 2013

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

  1. A.

    not in 2 NF

  2. B.

    in 2 NF but not in 3 NF

  3. C.

    in 3 NF but not in 2 NF

  4. D.

    in both 2 NF and 3 NF

Attempted by 1 students.

Sign up free to check your answer

Sign up free

Explore the full course: Rpsc Programmer

Loading lesson…