Consider a relation R(ABCDEG) with FD set F=(AB->C, AC->B, AD->B, B->D, BC->A,…

Consider a relation R(ABCDEG) with FD set F=(AB->C, AC->B, AD->B, B->D, BC->A, E->G) having decompositions

i) D1=(AB, BC, ABDE, EG)

ii) D2=(ABC, ACDE, ADG)

Find the correct statement(s).

  1. A.

    D1 is lossless decomposition

  2. B.

    D2 is lossless decomposition

  3. C.

    D1 is lossy decomposition

  4. D.

    D2 is lossy decomposition

Attempted by 40 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…