Practice mode DBMS and SQL

R(A, B, C) has functional dependencies AB -> C and C -> B, so its candidate keys are AB and AC. Which statement is true?

Correct answer A. R is in 3NF but not in BCNF

Explanation

BCNF requires the left side of every non-trivial dependency to be a superkey. C -> B fails, because C alone is not a superkey, so R is not in BCNF. 3NF has an extra escape clause: the dependency is allowed if the right-hand attribute is prime, that is, part of some candidate key. B belongs to key AB, so 3NF holds. This is the classic gap between 3NF and BCNF.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.