![]() |
VOOZH | about |
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 which. 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).
Dependency-preservation
Lossless-join
BCNF definition
3NF definition
This question is part of this quiz :
Database Design(Normal Forms),GATE-CS-2002,DBMS GATE CS PYQ QUIZ,Normalization & Normal Forms GATE CS PYQ Quiz