Exercise5
Tables (5)
Customer (Untitled4)
- ID (Key) — char(30) — Primary key — NOT NULL
- Name (Field) — char(30)
- Adress (Field2) — char(30)
- Phone (Field3) — char(30)
- Date (Field4) — char(30)
- Quantity (Field5) — char(30)
Department (Untitled2)
- stock (Key) — Primary key — NOT NULL
- ID (Key2) — char(30) — Foreign key → Shoe.ID — NOT NULL
Salesperson (Untitled5)
- ID (Key) — char(30) — Primary key — NOT NULL
- sales quota (Field) — char(30)
- ID (Key2) — char(30) — Foreign key → Shoe.ID — NOT NULL
Shoe (Untitled)
- ID (Key) — char(30) — Primary key — NOT NULL
- style (Field) — char(30)
- size (Field2) — char(30)
- color (Field3) — char(30)
- ID (Key3) — char(30) — Foreign key → Customer.ID — NOT NULL
- ID (Key2) — char(30) — Foreign key → Supplier.ID — NOT NULL
Supplier (Untitled3)
- ID (Key) — char(30) — Primary key — NOT NULL