Consider a relation R = {M, N, O, P, Q, R, S, T } with the following set of…

 Consider a relation R = {M, N, O, P, Q, R, S, T } with the following set of dependencies :

MN -> Q

M -> RQ

N -> R

R -> ST

Next, consider the following set of decompositions for the relation scheme R :

D1 = {R1 , R2, R3, R4} : R1 = {M , N, O, P}, R2 = {M , P, Q } , R3 = {N , R} , R4 = {R, S, T}

D2 = {R1 , R2, R3, R4} : R1 = {M , N, O}, R2 = {P, Q} , R3 = {N , R}, R4 = {R, S, T}

Which of the above decomposition (1) has/have lossless join property?

  1. A.

    Only D1

  2. B.

    Only D2

  3. C.

    Both D1 and D2

  4. D.

     Neither D1 nor D2

Attempted by 98 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…