Which of the following is TRUE ?

2025

Which of the following is TRUE ?

  1. A.

    Every relation in 3NF is also in BCNF.

  2. B.

    A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R.

  3. C.

    Every relation in BCNF is also in 3NF.

  4. D.

    No relation can be in both BCNF and 3NF

Attempted by 152 students.

Show answer & explanation

Correct answer: C

BCNF (Boyce-Codd Normal Form) is a stricter version of 3NF. Every relation in BCNF satisfies all requirements of 3NF, but the reverse is not true.

BCNF eliminates redundancy by ensuring that every determinant is a candidate key, which automatically satisfies the 3NF condition.

Explore the full course: Niacl Ao It Specialist