in Databases
253 views
0 votes
0 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:

in Databases
253 views

4 Comments

2000 tuples.
0
0

@Ashwin

join could have max of 2000 tupples.

0
0
it will be 2000 i think you took keys wrongly
0
0
thankyou it will be 2000.
0
0

1 Answer

0 votes
0 votes
2000 tuples.

The relation r1(P,Q,R) has primary key R i.e.,we have 1500 unique value of R in r1. while relation r2(R,U,V) has 2000 tuple with U as key i.e. it may contain duplicate value of R.