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?
- A.
Only D1
- B.
Only D2
- C.
Both D1 and D2
- D.
Neither D1 nor D2
Attempted by 98 students.
Sign up free to check your answer
Sign up freeLoading lesson…

