First time here? Checkout the FAQ!
+1 vote
17 views asked in Databases by (51 points)  
edited by | 17 views

1 Answer

+1 vote
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
answered by Boss (9.7k points)  

Top Users Aug 2017
  1. Bikram

    5272 Points


    4730 Points

  3. akash.dinkar12

    3514 Points

  4. manu00x

    3492 Points

  5. rahul sharma 5

    3188 Points

  6. makhdoom ghaya

    2700 Points

  7. just_bhavana

    2432 Points

  8. stblue

    2244 Points

  9. Tesla!

    2090 Points

  10. pawan kumarln

    1876 Points

25,071 questions
32,226 answers
30,232 users