closed by
514 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
closed by

Related questions

0 votes
0 votes
1 answer
3
night_fury asked Sep 23, 2018
731 views
The below decomposition is lossless or lossy and also dependency preserving or not?