GATE CSE
First time here? Checkout the FAQ!
x
0 votes
21 views

Describe the relational algebraic expression giving the relation returned by the following SQL query.

Select      SNAME
from        S
Where       SNOin
            (select     SNO
            from        SP
            where       PNOin
                        (select     PNO
                        from        P
                        Where       COLOUR='BLUE'))

 

asked in Databases by Veteran (76k points)   | 21 views

1 Answer

0 votes

SELECT the name of the Supplier who has supplied Blue Color Parts.

(as no detailed description is given I have taken it as supplier table, catalogue table and parts Table for convenience).

answered by Loyal (2.5k points)  


Top Users Mar 2017
  1. rude

    4272 Points

  2. sh!va

    2994 Points

  3. Rahul Jain25

    2804 Points

  4. Kapil

    2608 Points

  5. Debashish Deka

    2254 Points

  6. 2018

    1514 Points

  7. Vignesh Sekar

    1344 Points

  8. Akriti sood

    1262 Points

  9. Bikram

    1258 Points

  10. Sanjay Sharma

    1016 Points

Monthly Topper: Rs. 500 gift card

21,454 questions
26,775 answers
60,982 comments
22,994 users