You are given the following set of functional dependencies for a relation…

You are given the following set of functional dependencies for a relation R(A,B,C,D,E,F),

F = {AB → C, DC → AE, E → F }.

i. Is this relation in BCNF?

ii. Is the decomposition (A,B,C,D) (B,C,D,E,F) a dependency preserving decomposition?

  1. A.

    i: Yes, ii: Yes

  2. B.

    i: Yes, ii: No

  3. C.

    i: No, ii: No

  4. D.

    i: No, ii: Yes

Attempted by 46 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…