Consider a relation R = (A, B, C, D, E) with the set of functional dependency…

Consider a relation R = (A, B, C, D, E) with the set of functional dependency FDs

{A -> ABCDE, B -> C }. Which of the following statement is true?

  1. A.

    R1 = (A, C, D, E) and R2 = (B, C) are both in BCNF and preserve lossless-join.

  2. B.

    R1 = (A, B, D, E) and R2 = (B, C) are both in BCNF and preserve lossless-join.

  3. C.

    both (a) and (b)

  4. D.

    None of the above.

Attempted by 259 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…