541 views
2 votes
2 votes

1 Answer

Best answer
1 votes
1 votes
Given R1(P, Q, R) and R2(R ,U, V) where R is primary key in R1 and U is primary key in R2.
R in R1 is primary key so it should contain unique values assume 1,2,3,......1500(1500tuples)
There is no constraint on R in R2 so it can contain duplicate values assume 1,1,1,...1(2000 tuples)
Natural join is performed on the Common attribute i.e R
1 in R( R1 table) can map with 2000 1's in R( R2 table).
Hence maximum 2000 tuples are possible in natural join
selected by

Related questions

0 votes
0 votes
0 answers
1
Shreya2002 asked Aug 9, 2022
670 views
Consider a relation schema r(A, B, C). Number of elements in domain of attributes A, B and C are 4, 10 and 17 respectively. “ Minimum ” number of tuples possible in a...
–1 votes
–1 votes
1 answer
2
aoao asked Sep 26, 2018
343 views
0 votes
0 votes
1 answer
3
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
4
iarnav asked Dec 6, 2017
1,255 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...