ERD Exercise 1
Tables (4)
Untitled (product)
- Key (productNo) — Char(20) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — Char(20)
Untitled (part)
- Key (partNo) — Char(20) — Primary key — NOT NULL
- Field (description) — text
- Key (producerNo) — Char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (producer)
- Key (producerNo) — Char(14) — Primary key — NOT NULL
- Field (name) — Char(20)
- Field (address) — Char(30)
- Field (phone) — Char(10)
Untitled (product-part)
- Key (productNo) — Char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (partNo) — Char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (partQuantity) — int