Consider Relations R1 and R2 as given below – The number of tuples in output…
2024
Consider Relations R1 and R2 as given below –
The number of tuples in output of R1 ⋈ R2 will be –
- A.
20
- B.
5
- C.
6
- D.
7
- E.
Question not attempted
Attempted by 190 students.
Show answer & explanation
Correct answer: D
(q, r)
In R1 → appears 2 times
(p, q, r)
(m, q, r)
In R2 → appears 3 times
(q, r, n)
(q, r, a)
(q, r, b)
So combinations = 2 × 3 = 6
(e, f)
In R1 → 1 time
In R2 → 1 time
So combinations = 1 × 1 = 1
Total tuples after join:
6+1=7