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
P Nut Red
S Smith London P Bolt Green
S Jones Paris P Screw Blue
S Blake Paris P Screw Red
S Clark London P Cam Blue
S Adams Athens P Cog Red
SHIPMENT Table S# P# QTY
S# P# QTY
S P
S P
S P
S P
S P
S P
S P
S P
S P
S P
S P
S P Describe the nature of the referential integrity constraints 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
