Exercise 5

Tables (6)

Untitled (SHOES)

  • Key (shoeCode) — char(50) — Primary key — NOT NULL
  • Field (stock) — text

Untitled (SUPPLIER)

  • Key (supplyCode) — char(10) — Primary key — NOT NULL
  • Key (shoeCode) — char(50) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (shoeCode) — char(50) — Foreign key → Untitled.Key — NOT NULL
  • Key (special_shoes) — char(1) — Foreign key → Untitled.Key — NOT NULL
  • Key (cusID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (information) — text
  • Field (date) — integer
  • Field (quantity) — integer
  • Key (emID) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (SPECIAL_SUPPLIER)

  • Key (special_shoes) — char(1) — Primary key — NOT NULL

Untitled (CUSTOMER)

  • Key (cusID) — char(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(30)

Untitled (EMPLOYEE)

  • Key (emID) — char(5) — Primary key — NOT NULL
  • Field (quantity) — integer