ERD Exercise 5
Tables (5)
Untitled (shoes)
- Key (shoesCode) — Char — Primary key — NOT NULL
- Field (style) — Char
- Field (size) — Char
- Field (color) — Char
- Field (quantity) — Char
Untitled (supplier)
- Key (supplierCode) — Char — Primary key — NOT NULL
- Key (shoesCode) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (customer)
- Key (customerNo) — Char — Primary key — NOT NULL
- Field (name) — Char
- Field (address) — Text
- Field (phone) — Char
Untitled (salesperson)
- Key (spn) — Char — Primary key — NOT NULL
- Key (Salary(spn)) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (buy_information)
- Key (customerNo) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (shoesCode) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (spn) — Char — Foreign key → Untitled.Key — NOT NULL
- Field (buyDate) — Date
- Field (buyQuantity) — int