GATE CSE
First time here? Checkout the FAQ!
x
0 votes
14 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 (73.4k points)   | 14 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 (1.5k points)  
Top Users Jan 2017
  1. Debashish Deka

    9714 Points

  2. sudsho

    5558 Points

  3. Bikram

    5290 Points

  4. Habibkhan

    4900 Points

  5. Vijay Thakur

    4498 Points

  6. Arjun

    4418 Points

  7. saurabh rai

    4236 Points

  8. Sushant Gokhale

    4226 Points

  9. Kapil

    3848 Points

  10. santhoshdevulapally

    3808 Points

Monthly Topper: Rs. 500 gift card

19,449 questions
24,228 answers
53,953 comments
20,373 users