Multiple choice

Which of the following statements is true by the mean of BCNF?

  1. Not less join but dependency preserving

  2. Loss less join but not dependency preserving

  3. Loss less join and dependency preserving

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

 For every functional dependency, X->Y in a set F of functional dependencies are over. Unfortunately, BCNF is not dependency preserving. Dependency preserving is not a condition for BCNF decomposition.

Keep practicing — related questions