341 views
1 votes
1 votes

Consider the relation r1(PQR) and r2(RUV) with primary keys R and U respectively. The relation r1 contains 1500 tupples and r2contains 2000 tupples. The maximum size of the join  is:

my ans is 1500 but given ans is 2000. please correct me if 1500 is not the ans.

1 Answer

1 votes
1 votes
2000 is correct ans because R in relation r1 is primary key so

R have different values bt in r2 R is not primary key so it may have all same values so join will have 2000 tupples

Related questions

0 votes
0 votes
1 answer
1