If $|R| = 200$ tuples and $|S| = 50$ tuples, how many tuples does $R \…

Question

If $|R| = 200$ tuples and $|S| = 50$ tuples, how many tuples does $R 	imes S$ contain?

Accepted Answer

A. 10000 tuples, every (r, s) pair

Cross product enumerates every pair, so $|R 	imes S| = |R| \cdot |S| = 200 \cdot 50 = 10000$.
Sum or min/max would correspond to union, intersection or a single side, not product.

Answer

250 tuples (sum of the two)

Answer

50 tuples (the smaller of the two)

Answer

200 tuples (the larger of the two)

If $|R| = 200$ tuples and $|S| = 50$ tuples, how many tuples does $R \times S$ contain?

Keep practising Database Management Systems