Answered step by step
Verified Expert Solution
Question
1 Approved Answer
IN SQL 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)) --
IN SQL
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' ANDStep 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