1,019 views
2 votes
2 votes

1 Answer

1 votes
1 votes

 Actually, Both question 1 and 2 are same thing!

1. it's a Theeta join which will be considered as: 
Where R.A =< T.B((RUS)  X T)  and following will be output:


there will be 12 records.

2.
(RUS) Cross Product (T), Suppose RUS is renamed as R
there will be 12 records as follows:


Now apply condition as R.A =<T.B, In all the cases R.A is less than or equal to T.B.
But this second is technically wrong, Because there two relations involved in it, one is RUS and other is T, i don't think that
R.A =< T.B is correct because there is no relation as R in this query, until RUS is renamed as R.

PS:Cross Product and Natural Join both are Binary operators.

edited

Related questions

0 votes
0 votes
1 answer
2
srestha asked Dec 16, 2017
1,520 views
Consider the relation schema:Student(roll no, name course no)Enroll(roll no, course no,course name)The number of tuples in the student and enroll table is 30 and 40 respe...
3 votes
3 votes
2 answers
3
iarnav asked Dec 6, 2017
1,254 views
Say we have two relations R (a,b,c) and S (b,d,e).Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Joi...
4 votes
4 votes
4 answers
4
kauray asked May 9, 2017
3,678 views
Suppose you are given relations r(A, B) and s(A, C). Suppose that r has 10000 tuples, and s has 5000 tuples. Suppose attribute r.A has 1001 distinct values, and s.A also ...