55 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'))

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).