Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Observe the following tables, what is the foreign key between supplier and shipment table? Supplier Table SNUM SNAME STATUS CITY S 1 Smith 2 0

Observe the following tables, what is the foreign key between supplier and shipment table?
Supplier Table
SNUM
SNAME
STATUS
CITY
S1
Smith
20
London
S2
Jones
10
Paris
S3
Blake
30
Paris
S4
Clark
20
London
S5
Adams
30
Athens
Shipment Table
SNUM
PNUM
QTY
S1
P1
300
S1
P2
200
S1
P6
100
S2
P1
300
S2
P2
400
S3
P2
200
S4
P2
200
S4
P4
300
Part Table
PNUM
PNAME
COLOR
WEIGHT
P1
Nut
Red
12
P2
Bolt
Green
17
P3
Screw
Blue
17
P4
Screw
Red
14
P5
Cam
Blue
12
P6
Cog
Red
19

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2010 Barcelona Spain September 2010 Proceedings Part 2 Lnai 6322

Authors: Jose L. Balcazar ,Francesco Bonchi ,Aristides Gionis ,Michele Sebag

2010th Edition

364215882X, 978-3642158827

More Books

Students also viewed these Databases questions