973 views
2 votes
2 votes
Say I have two tables and they have some attributes in common, assume x is common, now will x will appear once in the output or twice for following cases?

Natural join

Cross product

Conditional join

Please explain.

1 Answer

Best answer
4 votes
4 votes

$R$

A B
1 2
1 3
2 1

$S$

A C
1 3
2 3
2 4

Case I) $R\Join S$

A B C
1 2 3
1 3 3
2 1 3
2 1 4

Case II) $R\times S$

A B A C
1 2 1 3
1 2 2 3
1 2 2 4
1 3 1 3
1 3 2 3
1 3 2 4
2 1 1 3
2 1 2 3
2 1 2 4

Case III) $R\Join _{A>1 } S$

A B A C
2 1 1 3
2 1 2 3
2 1 2 4

Related questions

1 votes
1 votes
1 answer
1
raginibhayana asked Feb 15, 2022
756 views
why don't we use the projection operator in conditional join?
1 votes
1 votes
1 answer
3
learner_geek asked Jan 24, 2018
1,256 views
My answer is not matching with any of the option.so what is the correct answer
2 votes
2 votes
1 answer
4
iarnav asked Nov 27, 2017
1,349 views
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!