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