563 views
1 votes
1 votes
Let R and S be two relations with the following schema

R(P−−,Q−−,R1,R2,R3)

S(P−−,Q−−,S1,S2)

where {P,Q} is the key for both schemas?

R:{⟨"1","abc","p1","p2","p3"⟩,

⟨"2","xyz","p1","p2","p3"⟩}

S:{⟨"1","abc","q1","q2","q3"⟩

⟨"2","def","q1","q2","q3"⟩

WHat is R  *S? WHERE * IS NATURAL JOIN.

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
2
aditi19 asked Nov 2, 2018
299 views
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
5 votes
5 votes
1 answer
4
Na462 asked Jun 14, 2018
4,180 views
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupp...