Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following 3 tables: PRODUCT(ID(PK), PNAME) SUPPLIER(SID(PK, SNAME) SUPPLIES(SUID(PFK), PID(PFK)) -- SUID references SUPPLIER's SID, PID references PRODUCT's ID FACTORY(FID(PK), OID(FK)) -- OID references
For the following 3 tables:
PRODUCT(ID(PK), PNAME)
SUPPLIER(SID(PK, SNAME)
SUPPLIES(SUID(PFK), PID(PFK)) -- SUID references SUPPLIER's SID, PID references PRODUCT's ID
FACTORY(FID(PK), OID(FK)) -- OID references SUPPLIER' SID
To get suppliers who are not supplying any products, what goes in the blank?
SELECT SNAME
FROM SUPPLIER
WHERE SID NOT IN _____
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started