Given two relations R and S, where R contains N 1 tuples and S contains N 2 tuples (N 2 > N 1 > 0), give the minimum and maximum cardinality for the result relation for each of the following relational algebra expressions and in each case state any assumptions about the schemas that are required to make the expression meaningful:

Question

(a) R ? S
(b) R ? S
(c) R – S
(d) R x S
(e) ?a = 1(R)
(f) ? a (R)

Answer 1