BCNF is not used for cases where a relation has
- A. Two (or more) candidate keys
- B. Two candidate keys and composite
- C. The candidate key overlap
- D. Two mutually exclusive foreign keys
Answer: C. The candidate key overlap
Explanation: BCNF is strict; sometimes 3NF is preferred if dependency preservation is needed, especially with overlapping candidate keys.