Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

3rd Edition

0071107010, 978-0071107013

More Books

Students also viewed these Databases questions

Question

What is primary liability?

Answered: 1 week ago