Register

JOIN Doubt

306 views
0 votes
0 votes
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?
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
1 answer
2
Na462 asked Jun 14, 2018
4,249 views
MadeEasy Test Series: Databases - Natural Join
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 tupples. The number of resultant tuple in are ________.
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...
User Avatar
1 votes
1 votes
0 answers
3
iarnav asked Nov 27, 2017
579 views
DBMS SELF DOUBT
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", ... ;,"q3"⟩ ⟨"2","def","q1","q2","q3"⟩ WHat is R *S? WHERE * IS NATURAL JOIN.
Let R and S be two relations with the following schemaR(P−−,Q−−,R1,R2,R3)S(P−−,Q−−,S1,S2)where {P,Q} is the key for both schemas?R:{⟨"1","abc","p1","p2"...
User Avatar
Link Copied!