excercise 5

Tables (7)

customer (Untitled4)

  • unique customer number (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — char(11)
  • unique supplier code (Key2) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL

department (Untitled2)

  • lnventory amount (Key) — Primary key — NOT NULL

employee (Untitled6)

  • employee number (Key) — char(10) — Primary key — NOT NULL

purchase (Untitled5)

  • date (Key) — char(8) — Primary key — NOT NULL
  • quantity (Field) — char(100)
  • Field2
  • unique supplier code (Key2) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL
  • employee number (Key3) — char(10) — Foreign key → employee.employee number — NOT NULL
  • sales commission (Key4) — char(10) — Foreign key → salary.sales commission — NOT NULL

salary (Untitled7)

  • sales commission (Key) — char(10) — Primary key — NOT NULL
  • sales quota (Field) — char(!0)

suppliers (Untitled3)

  • unique supplier code (Key) — char(30) — Primary key — NOT NULL
  • credit (Field) — char(30)
  • cash (Field2) — char(20)
  • style (Key2) — char(30) — Foreign key → unique product code.style — NOT NULL

unique product code (Untitled)

  • style (Key) — char(30) — Primary key — NOT NULL
  • size (Field) — char(5)
  • color (Field2) — char(10)
  • Field3
  • lnventory amount (Key2) — Foreign key → department.lnventory amount — NOT NULL
  • unique supplier code (Key3) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL