DB_ERDexercise1_0929
Tables (4)
Untitled (MAKER)
- Key (makeID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (add) — char(50)
- Field (phone) — char(11)
Untitled (PROD_PART)
- Key (ppNo) — char(20) — Primary key — NOT NULL
- Key (partNo) — char(10) — Foreign key → Untitled3.Key — NOT NULL
- Key (prodNo) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Field (qty) — char(10)
Untitled2 (PRODUCK)
- Key (prodNo) — char(10) — Primary key — NOT NULL
- Field (expl) — char(100)
- Field (price) — char(10)
Untitled3 (PART)
- Key (partNo) — char(10) — Primary key — NOT NULL
- Field (expl) — char(100)
- Key (makeID) — char(10) — Foreign key → Untitled.Key — NOT NULL