Question: For the questions 1 7 = 2 8 , consider three relations called R 1 , R 2 , and R 3 . The number
For the questions consider three relations called and The number of tuples in R R and R are and respectively. The number of attributes of R R and R are and Use the following choices to answer each question.
a
b
c
d
e
f
g
h
i
j
k
l
m none of the above
A what would be the minumum number of tuples the result will contain If we apply SELECT
from R WhERE
what would be the maximum number of tuples the result will contain If we apply SELECT
from WherE
what would be the minumum number of attributes the result will contain If we apply SELECT FROM WHERE
what would be the maximum number of attributes the result will contain If we apply SELECT FROM WHERE
Assuming that and are unioncompatible, If we UNION and relations, what would be the minimum number of tuples the result will have?
Assuming that and are unioncompatible, If we UNION and relations, what would be the minimum number of attributes the result will have?
would be the maximum number of attributes the result will have? What would be the minimum number of tuples the result set will have if we JOIN and over a common attribute or a set of attributes
What would be the maximum number of tuples the result set will have if We JOIN and over a common attribute or a set of attributes
What would be the minimum number of attribut
and over a cor a set of atributes
and over a common attribute or a set of attributes
What would be the maximum number of attributes the result set will have if we JOIN
result set will have if we JOIN
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
