GATEverse
← GATE CSE 2005

Q30

MCQ1 mark, −0.25

Let r be a relation instance with schema R = (A, B, C, D). We define r1=πA,B,C(R)r_1 = \pi_{A, B, C} (R) and r2=πA,D(r)r_2=\pi_{A, D} (r). Let s=r1 ∗ r2s =r_1 \: * \: r_2 where ∗* denotes natural join. Given that the decomposition of rr into r1r_1 and r2r_2 is lossy, which one of the following is TRUE?

Sign in to save attempts.

Loading…