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 ids of factories which might make the product "Acme Jetpack", what goes in the blank?
SELECT FID
FROM PRODUCT, SUPPLIER, SUPPLIES, FACTORY
WHERE PNAME = 'Acme Jetpack' AND ____
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