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 decomposition for the relation scheme R :

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

  1. A.

    Only D1

  2. B.

    Only D2

  3. C.

    Both D1 and D­2

  4. D.

    Neither D1 nor D2

Attempted by 174 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…