Question: The following SQL querySELECT P . pnameFROM Parts P , Catalog C , Suppliers SWHERE P . pid = C . pid AND C .

The following SQL querySELECT P.pnameFROM Parts P, Catalog C, Suppliers SWHERE P.pid = C.pid AND C.sid = S.sidAND S.sname = 'Acme Widget Suppliers'AND NOT EXISTS ( SELECT *FROM Catalog C1, Suppliers S1WHERE P.pid = C1.pid AND C1.sid = S1.sidANDS1.sname <> 'Acme Widget Suppliers')has the equivalent English query: a. The pnames of parts supplied by Acme Widget Suppliers and no one else. b. The pnames of parts supplied by Acme Widget Suppliers. c. The pnames of parts supplied by Acme Widget Suppliers and someone else. d. The pnames of parts not supplied by Acme Widget Suppliers. None of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!