ERD EXCERCISE 5
Tables (8)
Untitled (SHOES)
- Key (shoesID) — integer — Primary key — NOT NULL
- Field (style) — char(30)
- Field (size) — char(20)
- Field (color) — char(20)
- Field (price) — char(20)
Untitled (department)
- Key (departID) — integer — Primary key — NOT NULL
- Field (quantity) — char(30)
- Key (shoesID) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (SUPPLIER)
- Key (supplierID) — integer — Primary key — NOT NULL
- Field (address) — char(30)
- Field (phone) — char(10)
Untitled (CUSTOMER)
- Key (customerNO) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — char(20)
Untitled (PURCHASE)
- Key (customerNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (salesperID) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date
- Field (quantity) — char(30)
- Field
Untitled (SALESPERSON)
- Key (salesperID) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — char(10)
Untitled (SHOES-SUPPLIER)
- Key (shoesID) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (supplierID) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (customerNO) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (COMPENSATION)
- Key (salesperID) — integer — Foreign key → Untitled.Key — NOT NULL