Database MCQ

1:

 Let r be a relation instance with schema R = (A, B, C, D). We define r1 =∏ A,B,C (r) and r2 = ∏A, D (r)
Let S = r1* r2  where * denotes natural join. Given that the decomposition of r into r1 and r2 is lossy, which one of the following is TRUE?

A.

S ⊂ r

B.

r ∪ s  =  r

C.

r ⊂ s

D.

r*s = s

 

Answer : C

Explanation :

Write your comments here:


Report Error
 

Option: A

Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here.