edited by
373 views

1 Answer

1 votes
1 votes
C is the correct option.

For the part a.) There is no join symbol after part.

Fort part b:) after finding Red products say R1,R2,R3 we are just doing a cross prodcut with other tables.So there is no condition which says pick only supplier matching with R1,R2,R3

C:) First we filter Red product Id. R1,R2,R3,then we get the Sid supplying those Parts and then we get names of those IDs.

So c is corect option here

Related questions

0 votes
0 votes
1 answer
1
Ashutosh_17 asked Mar 30, 2023
791 views
Let R be a relation of degree 5 then the total number of projections possible on R is ___?
0 votes
0 votes
0 answers
4
aashijn asked Apr 28, 2022
1,332 views
employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name) a. Find the names of all empl...