Suppose you are given a relation R=(A,B,C,D,E) with the following functional…

Suppose you are given a relation R=(A,B,C,D,E) with the following functional dependencies: {BC → ADE, D → B}.

If the relation is not in BCNF, decompose it until it becomes BCNF.

  1. A.

    Relation does not get decomposed into BCNF

  2. B.

    Relation will decompose into BCNF

  3. C.

    Cannot say

  4. D.

    Data insufficient

Attempted by 200 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…