Question: The following SQL querySELECT P . pnameFROM Parts P , Catalog C , Suppliers SWHERE P . pid = C . pid AND C .
The following SQL querySELECT PpnameFROM Parts P Catalog C Suppliers SWHERE Ppid Cpid AND Csid SsidAND Ssname 'Acme Widget Suppliers'AND NOT EXISTS SELECT FROM Catalog C Suppliers SWHERE Ppid Cpid AND Csid SsidANDSsname '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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
