The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 votes

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 (115k points) | 120 views

1 Answer

+1 vote

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 (3.8k points)

Related questions

0 votes
0 answers
asked Dec 19, 2016 in Databases by jothee Veteran (115k points) | 96 views
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
48,720 questions
52,822 answers
68,569 users