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 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).(A) Dependency-preservation(B) Lossless-join(C) BCNF definition(D) 3NF definition

Answer»


Discussion

No Comment Found

Related InterviewSolutions