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.
Answer checked How we write and check questions
Discussion