edited by
319 views
1 votes
1 votes

Consider the join of relation R with a relation S. If R has $m$ tuples and S has $n$ tuples, then the maximum and minimum sizes of the join, respectively, are __________.

  1. $m+n$ and $0$
  2. $m+n$ and $|m-n|$
  3. $mn$ and $0$
  4. $mn$ and $m+n$
edited by

1 Answer

Best answer
1 votes
1 votes

here option C is correct because here we find join so first we performed cross-product then so maximum in which no attribute is common so it multiple every element so its m*n but  if we talk about minimum means suppose R= m tuple  and S= n tuple(0 tuple) so here cross product no pair is result so its min is 0.

selected by
Answer:

Related questions

0 votes
0 votes
1 answer
1
Bikram asked Nov 26, 2016
228 views
A functional dependency of the form x → y is trivial ify ⊆ xy ⊂ xx ⊆ yx ⊂ y
0 votes
0 votes
1 answer
2
Bikram asked Nov 26, 2016
293 views
What does the following Tuple Relational Calculus query produce?The expression σθ1 (E1 ⋈θ2 E2) is the same as: E1 ⋈θ1^ θ2 E2 (σθ1 E1) ∧ (σθ2 E2 ) E1 ⋈ θ...