in Databases closed by
516 views
0 votes
0 votes
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 schema 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?

A. Only D1            B. Only D2              C.Both D1 and D2                D. Neither D1 nor D2
in Databases closed by
by
516 views

Related questions