Consider the following given relations: R(a,b,c) , S(c,d,e) R has 1500 tuples…
Consider the following given relations:
R(a,b,c) , S(c,d,e)
R has 1500 tuples and S has 2000 tuples at a instance of time and the non-null attribute c in S referencing the attribute c in R, let X be the maximum tuples possible in R⋈S and Y be the minimum number of tuples possible in R⋈S than X-Y = __________
Answer: 0 — Here the attribute c of relation S refers the attribute c of relation R, so while natural join each attribute of S relates with exact one attribute of R So…
Attempted by 9 students.
Show answer & explanation
Correct answer: 0
Here the attribute c of relation S refers the attribute c of relation R, so while natural join each attribute of S relates with exact one attribute of R
So min = 2000 and max =2000
Loading lesson…