Which of the following relation schema is always in BCNF?
2017
Which of the following relation schema is always in BCNF?
- A.
R(A, B, C, D)
- B.
R(A, B, C)
- C.
R(A, B, C, D, E)
- D.
R(A, B)
Attempted by 306 students.
Show answer & explanation
Correct answer: D
A binary relation schema R(A, B) containing exactly two attributes is always in BCNF. For any non-trivial functional dependency X → Y in a binary relation, the left-hand side X will always be a superkey, completely satisfying BCNF criteria.
Correct Option: D