GATE CSE
First time here? Checkout the FAQ!
x
0 votes
19 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 (75.6k points)   | 19 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 Active (2.5k points)  
Top Users Feb 2017
  1. Arjun

    5410 Points

  2. Bikram

    4230 Points

  3. Habibkhan

    3952 Points

  4. Aboveallplayer

    3086 Points

  5. Debashish Deka

    2564 Points

  6. sriv_shubham

    2318 Points

  7. Smriti012

    2240 Points

  8. Arnabi

    2008 Points

  9. mcjoshi

    1696 Points

  10. sh!va

    1684 Points

Monthly Topper: Rs. 500 gift card

20,864 questions
26,030 answers
59,704 comments
22,144 users