Question: Assume we have two relations R ( a , b ) and S ( b , c ) . All three attributes ( a ,
Assume we have two relations Rab and Sbc All three attributes a b and c are integer attributes. Assume that Relation R contains the following tuples: and Assume that Relation S contains the following tuples and
R
a b
S
b c
a Give an example of an attribute or a combination of attributes that cannot be a primary key for relation S why? Points
c How many tuples are in the result of Natural Join between R and S point
d Show the output of the following query points
SELECT a
FROM RS
WHERE Rb Sb and Sc
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
