##### The maximum size of the join r1⋈ r2 is

Consider the relations r_{1}(P, Q, R) and r_{2}(R, S, T) with primary keys P and R respectively. The relation r_{1} contains 2000 tuples and r_{2} contains 2500 tuples. The maximum size of the join r_{1}⋈ r_{2} is :

- 2000
- 2500
- 4500
- 5000

_{1}(P, Q, R) and r_{2}(R, S, T)R1

pR2

rthen R1⋈R2 is

therefore, maximum size of the join r

_{1}⋈ r_{2 }is minimum of two relations, reason being r of R1 refers to r of R2 so for every matching only there will be tuple in final natural join.So, ans is min(2000,2500)= 2000.