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:
(a) R $\cup$ S
(b) R $\cap$ S
(c) R - S
(d) R x S
(e) $\sigma$a = 1 (R)
(f) $\Pi$ a (R)

Question

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:
(a) R $\cup$ S
(b) R $\cap$ S
(c) R - S
(d) R x S
(e) $\sigma$a = 1 (R)
(f) $\Pi$ a (R)

Quizplus · Accepted Answer

The Answer of 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:
(a) R $\cup$ S
(b) R $\cap$ S
(c) R - S
(d) R x S
(e) $\sigma$a = 1 (R)
(f) $\Pi$ a (R)

Given Two Relations R and S, Where R Contains N1 ∪\cup∪

Given Two Relations R and S, Where R Contains N₁ $\cup$