Multiple choice

Which of the following is TRUE?

  1. Every relation is 3NF is also in BCNF.

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

  3. Every relation in BCNF is also in 3NF.

  4. No relation can be in both BCNF and 3NF.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

1 is false since BCNF is stricter than 3NF. 2 is false since the definition given here is of 2NF. 3 is true, since BCNF is stricter than 3NF, every relation in BCNF satisfies all the properties of 3NF.

Keep practicing — related questions