Register

natural join and equi join

256 views
2 votes
2 votes
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
User Avatar

1 Answer

0 votes
0 votes
I think natural join is same as innerjoin. Equijoin is I think cartesian product followed by comparison over some/all attributes for equality( as opposed to comparison of all possible attributes for equality).
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Sanjay Sharma asked Sep 3, 2016
127 views
natural join and equi join
is natural join is same as equijoin or innerjoin or natural join is defined as the caresian product followed by selection/projection
is natural join is same as equijoin or innerjoin or natural join is defined as the caresian product followed by selection/projection
User Avatar
0 votes
0 votes
0 answers
2
set2018 asked Sep 29, 2017
363 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,011 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,719 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!