Excercise1_0923
Tables (5)
COMPANY
- FK (Pro ID) — INT(20) — Primary key — NOT NULL
- FK (Producer ID) — INT(20) — Primary key — NOT NULL
- Field (Company Name) — CHAR(40)
- Field2 (Location) — CHAR(100)
PART
- PK (Part ID) — INT(20) — Primary key — NOT NULL
- FK (Pro ID) — INT(20) — Foreign key → PART_NUM_PER_PRODUCT.FK — NOT NULL
- Field (Description) — CHAR(100)
PART_NUM_PER_PRODUCT (Part_Num_Per_Product)
- FK (Pro ID) — INT(20) — Primary key — NOT NULL
- FK (Part ID) — INT(20) — Primary key — NOT NULL
- Field (Part Count) — INT(100)
PRODUCER
- PK (Producer ID) — INT(20) — Primary key — NOT NULL
- FK (Pro ID) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
- FK (Producer ID2) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
- Field (Name) — CHAR(100)
- Field (Address) — CHAR(200)
- Field (Phone) — INT(20)
PRODUCT
- PK (Pro ID) — INT(20) — Primary key — NOT NULL
- FK (Part ID) — INT(20) — Foreign key → PART_NUM_PER_PRODUCT.FK — NOT NULL
- FK (Producer ID) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
- Field (Description) — CHAR(100)
- Field (Price) — INT(20)