Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

3. Who would the members be?

Answered: 1 week ago

Question

4. Who would lead the group?

Answered: 1 week ago