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