Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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).
    1. Dependency-preservation
    2. Lossless-join
    3. BCNF definition
    4. 3NF definition
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.



Your comments will be displayed only after manual approval.