Relation S... contains information about suppliers SNAME STATUS CITY Supplier number (PK) primary ke Supplier name Supplier status le.g., reliability code between 1 and 5,supplier's location y....varchar with i being best, 5 worst... int Relation P. contains information about parts PNAME Name of the part+ varchar Weight supplier location Part number (PK) primary key Part color " Relation SP. contains information about which parts are supplied by which suppliers in which quantities+ QTY Part color Supplier number (PK) (FK)+ Part number (PK) (FK) art of primary kev, foreign ke yvarchar- art of primar key. varchar- MORE COMPACT FORM PH SNO (PK) SNAMESTATUS CITY PNO (PK).PNAME COLOR WEIGHT SP+ SNO PK) (FK) PNO (PK) (FK) QTY Figure 1. Supplier-Parts DB Tables* PH SNO(PK) | SNAME | STATUS Smith Jones Blake PNO PKPNAME COLOR WEIGHT 20 10 30 20 30 P1 P2 P3 P4 P5 Nut S2 S3 S4 S5 Blue Paris 14 Athens Cam Blue SNO 300 200 P1 P2 P3 P4 P5 P1 P2 P3 Pl P2 P3 P2 P4 200 100 300 S2 S2 S3 S3 S3 S4 S4 S5 200 100 200 200 200 Figure 2. Content of the Supplier-Parts DB Tables