Exercise 1
Tables (3)
Untitled (COMPANY)
- Key (product) — char(5) — Primary key — NOT NULL
- Field (productNo) — char(20)
- Field (productExplain) — char(20)
- Field (price) — char(20)
Untitled (COMPONENT)
- Key (component) — char(5) — Primary key — NOT NULL
- Key (ssn) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (componentID) — char(20)
- Field (componentExplain) — char(20)
- Key (product) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCER)
- Key (ssn) — char(5) — Primary key — NOT NULL
- Key (component) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — char(5)
- Field (address) — char(5)
- Field (phone) — char(5)
- Key (product) — char(5) — Foreign key → Untitled.Key — NOT NULL