For a relation known to be in 3NF but not BCNF, which dependency pattern…

ISRO Scientist/Engineer SC 2007Modified — slightly modified from the official paper; see the solution

For a relation known to be in 3NF but not BCNF, which dependency pattern explains the gap?

  1. A.

    Two (or more) candidate keys

  2. B.

    Two candidate keys and composite

  3. C.

    A non-superkey determinant with a prime dependent attribute

  4. D.

    Two mutually exclusive foreign keys

Attempted by 1009 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…