Relational-Algebra

Question 15

Consider the relations r₁(P, Q, R) and r₂(R, S, T) with primary keys P and R respectively. The relation r₁ contains 2000 tuples and r₂ contains 2500 tuples. The maximum size of the join r₁⋈ r₂ is :

A	2000
B	2500
C	4500
D	5000

Database-Management-SystemRelational-AlgebraGATE 2006-IT

Question 15 Explanation:

r₁⋈ r₂ is a join operation done on the common attribute R. So this can have 2000 tuples.

Correct Answer: A

Question 15 Explanation:

r₁⋈ r₂ is a join operation done on the common attribute R. So this can have 2000 tuples.