Register

natural join and equi join

127 views
0 votes
0 votes
is natural join is same as equijoin or innerjoin

or natural join is defined as the caresian product followed by selection/projection
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

2 votes
2 votes
1 answer
1
Sanjay Sharma asked Sep 3, 2016
257 views
natural join and equi join
is natural join is same as equijoin or innerjoin or natural join is defined as the caretesian product followed by selection/projection or both above are same
is natural join is same as equijoin or innerjoinor natural join is defined as the caretesian product followed by selection/projectionor both above are same
User Avatar
0 votes
0 votes
0 answers
2
set2018 asked Sep 29, 2017
367 views
equi natural inner join
Can we say inner and self join are same ?
Can we say inner and self join are same ?
User Avatar
3 votes
3 votes
1 answer
3
techbrk3 asked Nov 9, 2017
2,035 views
Natural Join - R contains 75 tuples and S contains 25 tuples. What is the least and most number of tuples?
R(A, B) foreign key B refers S.S(A, B) foreign key A refers R. (primary keys are bold)None of the attributes is nullable. R contains 75 tuples and S contains 25 tuples. W...
User Avatar
1 votes
1 votes
3 answers
4
Purple asked Jan 24, 2016
1,731 views
Relation between Intersection and natural inner join on common column
When , then the cost of computing is (A) the same as R S (B) greater the R S (C) less than R S (D) cannot say anything
When , then the cost of computing is(A) the same as R S (B) greater the R S(C) less than R S (D) cannot say anything
User Avatar
Link Copied!