ERD Exercise 1
Tables (5)
Untitled (PRODUCT)
- Key (PID) — char(20) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int(10)
- Field (Pname) — char(20)
- Field (category) — char(30)
Untitled (COMPONENT)
- Key (CID) — char(20) — Primary key — NOT NULL
- Field (description) — text
- Field (Cname) — char(30)
- Field (price) — int(10)
- Key (MID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (catID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MANUFACTURER)
- Key (MID) — char(20) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(50)
- Field (phone) — char(12)
- Field (email) — char(30)
- Field (fax) — char(30)
- Field (grade) — textd
- Field (description)
Untitled (PRODUCT_COMPONENT)
- Key (PID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (CID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int(10)
Untitled (CATEGORY)
- Key (catID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (description) — text