-
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, but it is not known which is to make a guaranteed identification, which one of the following tests should be used on the deocmpositions? (Assume that the closures of F and G are available).
-
- Dependency-preservation
- Lossless-join
- BCNF definition
- 3NF definition
- Dependency-preservation
Correct Option: C
BCNF is more stricter than 3NF. So if we check database for BCNF, then it will definitely be in 3NF. Hence (c) is correct option.