1,699 views
4 votes
4 votes
Does out put of conditional join contains duplicates?I know that it gives distinct in natural join as the projection operator removes duplicate rows. But in conditional join does this thing holds true?

2 Answers

0 votes
0 votes
As we know the conditional join is just an extension of natural join....in conditional join even we perform cross product and apply condition but at last we have to project the attributes which will definitely removes the duplicates....
0 votes
0 votes

From Korth book

The theta join operation is a variant of the natural-join operation that allows us
to combine a selection and a Cartesian product into a single operation
 

So theta join is just a generalized version of natural join, so duplicates will be removed.

Related questions

1 votes
1 votes
1 answer
1
raginibhayana asked Feb 15, 2022
755 views
why don't we use the projection operator in conditional join?
2 votes
2 votes
1 answer
2
rahul sharma 5 asked Jan 5, 2017
971 views
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 joinCro...
0 votes
0 votes
1 answer
3
Fida asked Oct 18, 2018
555 views
I'm confused when to you which join and cross product. Please help me