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