Consider two database relations R and S having 3 tuples in R and 2 tuples in…
2017
Consider two database relations R and S having 3 tuples in R and 2 tuples in S. What is the maximum number of tuples that could appear in the natural join of R and S?
- A.
6
- B.
2
- C.
3
- D.
5
Attempted by 485 students.
Show answer & explanation
Correct answer: A
The maximum number of tuples in a natural join occurs when every tuple of R matches with every tuple of S on the common attribute(s). So, maximum tuples = |R| × |S| = 3 × 2 = 6.