The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
123 views
Select      SNAME
from        S
Where       SNOin
            (select     SNO
            from        SP
            where       PNOin
                        (select     PNO
                        from        P
                        Where       COLOUR='BLUE'))

What relations are being used in the above SQL query? Given at least two attributes of each of these relations.

asked in Databases by Veteran (98.9k points) | 123 views

2 Answers

0 votes
relation S(sname , sno) and relation P(pno,colour)
answered by Junior (533 points)
0 votes

There are 3 relations exists here:

S(SNAME, SNO)

SP(SNO, PNO)

P(PNO, COLOUR)

answered by Boss (23.2k points)


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

34,849 questions
41,832 answers
119,100 comments
41,454 users