Question: 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
Consider the following relational schema:
Supplierssid:integer, sname:string, city:string, street:string
Partspid:integer, pname:string, color:string
Catalogsid:integer, pid:integer, cost:real
Consider the following relational query on the above database:
SELECT Ssname
FROM Suppliers S
WHERE Ssid NOT IN SELECT Csid
FROM Catalog C
WHERE Cpid NOT IN SELECT Ppid
FROM Parts P
WHERE Pcolor '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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
