Multiple choice

Which of the following is false statement about BCNF (Boyce Codd Normal Form) in relational database?

  1. BCNF is the higher version of third normal form (3NF).

  2. A database design is in BCNF if each entity in the set constitute the design.

  3. BCNF performs dependency preservation.

  4. All of the above.

  5. Both (2) and (3).
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Every BCNF decomposition is not dependency preservation. It means that one attribute in the relational schema does not include dependency.

Keep practicing — related questions