Relation R is decomposed using a set of functional dependencies, F and…

GATE · 2002 · CS · Question 2 subparts

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).

  1. A.

    Dependency-preservation

  2. B.

    Lossless-join

  3. C.

    BCNF definition

  4. D.

    3NF definition

Attempted by 435 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…