BCNF can be achieved from 3NF by removing which of the following?
2025
BCNF can be achieved from 3NF by removing which of the following?
Answer: B. overlapping dependencies — To achieve BCNF from 3NF, overlapping dependencies must be removed. While 3NF eliminates transitive dependencies where the determinant is not a superkey, it…
- A.
transitive dependencies
- B.
overlapping dependencies
- C.
partial dependencies
- D.
repeating groups
Attempted by 647 students.
Show answer & explanation
Correct answer: B
To achieve BCNF from 3NF, overlapping dependencies must be removed. While 3NF eliminates transitive dependencies where the determinant is not a superkey, it allows them if the determinant is prime. BCNF requires every determinant to be a candidate key, thus resolving overlapping candidate keys or prime attribute dependencies that 3NF permits.
Loading lesson…