Which of the following relation schema is always in BCNF?
2017
Which of the following relation schema is always in BCNF?
Answer: D. R(A, B) — 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,…
- A.
R(A, B, C, D)
- B.
R(A, B, C)
- C.
R(A, B, C, D, E)
- D.
R(A, B)
Attempted by 853 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
Explore the full course: Iocl Engineers Officers Grade A Paper 2
Loading lesson…