Question: SUPPLIER Table ( S# , SNAME, STATUS, CITY ) PART Table ( P# , PNAME, COLOR, WEIGHT ) P# PNAME COLOR WEIGHT S# SNAME STATUS

SUPPLIER Table (S#, SNAME, STATUS, CITY) PART Table (P#, PNAME, COLOR, WEIGHT)
P# PNAME COLOR WEIGHT
S# SNAME STATUS CITY ------------------
--------------------------- P1 Nut Red 12
S1 Smith 20 London P2 Bolt Green 17
S2 Jones 10 Paris P3 Screw Blue 17
S3 Blake 30 Paris P4 Screw Red 14
S4 Clark 20 London P5 Cam Blue 12
S5 Adams 30 Athens P6 Cog Red 19
SHIPMENT Table (S#, P#, QTY)
S# P# QTY
--------------
S1 P1300
S1 P2200
S1 P3400
S1 P4200
S1 P5100
S1 P6100
S2 P1300
S2 P2400
S3 P2200
S4 P2200
S4 P4300
S4 P54006. Describe the nature of the referential integrity constraint(s) that involve the PART and SHIPMENT tables.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!