Multiple choice

Relation R is decomposed using a set of functional dependencies F and relation S is decomposed using another set of functional dependencies G. One decomposition is definitely BCNF, the other is definitely 3NF. To make a guaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closures of F and G are available).

  1. Dependency preservation

  2. Lossless join

  3. BCNF definition

  4. 3NF definition
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

BCNF is a stricter normal form than 3NF. So if we check database for BCNF, then it will definitely be in 3NF.

Keep practicing — related questions