GATE Papers >> CSE >> 2009 >> Question No 55

Question No. 55 CSE | GATE 2009

Consider the following relational schema:

Suppliers(sid:integer, sname:string, city:string, street:string)
Parts(pid:integer, pname:string, color:string)
Catalog(sid:integer, pid:integer, cost:real)

Consider the following relational query on the above database:

SELECT S.sname
FROM Suppliers S
WHERE S.sid NOT IN (SELECT C.sid
                                FROM Catalog C
                                WHERE C.pid NOT (SELECT P.pid
                                                            FROM Parts P
                                                            WHERE P.color<> 'blue'))

Assume that relations corresponding to the above schema are not empty. Which one of the following is the correct interpretation of the above query?


Answer : (A) Find the names of all suppliers who have supplied a non-blue part.


Comments
mdrlyR http://pills2sale.com/ levitra nizagara

Posted on  18/10/2020 17:41:11  by  dobsonz
FWWNuj http://pills2sale.com/ levitra nizagara

Posted on  18/10/2020 20:41:41  by  dobsonz
YiqDlj https://www.quora.com/What-the-top-SEO-keywords-for-essay-you-know/answer/Alan-Smith-1772 write my essay

Posted on  03/12/2020 22:55:44  by  dobson
d9GQ3Z https://www.quora.com/What-the-top-SEO-keywords-for-essay-you-know/answer/Alan-Smith-1772 write my essay

Posted on  04/12/2020 01:43:24  by  dobson
aYkkot http://xnxx.in.net/ xnxx videos

Posted on  12/12/2020 22:59:44  by  johnan
83Y2qW http://xnxx.in.net/ xnxx videos

Posted on  13/12/2020 00:49:23  by  johnan
oPpNDU https://writemyessayforme.web.fc2.com/

Posted on  13/12/2020 04:32:47  by  dobson
vM6nrp https://writemyessayforme.web.fc2.com/

Posted on  13/12/2020 05:54:01  by  dobson
2qGvKm https://writemyessayforme.web.fc2.com/#writemyessay

Posted on  15/12/2020 05:32:15  by  dobson
oW52ub https://writemyessayforme.web.fc2.com/#writemyessay

Posted on  15/12/2020 06:53:50  by  dobson
ZTpgcu https://writemyessayforme.web.fc2.com/octavio-paz-essay-day-of-the-dead.html

Posted on  09/01/2021 12:04:50  by  dobson
PHHgx7 https://writemyessayforme.web.fc2.com/octavio-paz-essay-day-of-the-dead.html

Posted on  09/01/2021 12:08:19  by  dobson
MOjBFa http://waldorfdollshop.us/ waldorf doll

Posted on  09/01/2021 16:24:08  by  johnanz
afDgGU http://waldorfdollshop.us/ waldorf doll

Posted on  09/01/2021 16:28:13  by  johnanz
nMLH1S https://beeg.x.fc2.com/

Posted on  26/01/2021 17:17:47  by  markus
U0hxj5 https://beeg.x.fc2.com/

Posted on  26/01/2021 17:21:43  by  markus
plSWzh https://buyzudena.web.fc2.com/

Posted on  27/01/2021 13:54:18  by  markus
axxbGy https://buyzudena.web.fc2.com/

Posted on  27/01/2021 14:32:50  by  markus
Leave a comment