Consider the relation schema R(S, T, U, V) with the following functional…

PYQ UGC NET 2014Modified — slightly modified from the official paper; see the solution

Consider the relation schema R(S, T, U, V) with the following functional dependencies:

  • S → T

  • T → U

  • U → V

  • V → S

Which normal-form classification is correct for relation R?

  1. A.

    Not in 2NF

  2. B.

    In 2NF but not in 3NF

  3. C.

    In 3NF but not in 2NF

  4. D.

    In both 2NF and 3NF

Attempted by 413 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…