Test series

Question

Consider the relation r₁(P, Q, R) and r₂(R, U, V) with primary keys R and U respectively. The relation r₁ contains 1500 tupples and r₂contains 2000 tupples. The maximum size of the join  is:

Comments

2000 tuples.

---

@Ashwin

join could have max of 2000 tupples.

---

it will be 2000 i think you took keys wrongly

---

thankyou it will be 2000.

Answer 1

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.