ex5

Tables (4)

customer (Untitled4)

  • customercode (Key) — char(16) — Primary key — NOT NULL
  • salesamount (Field) — int(1000)
  • style (Field2) — char(20)
  • size (Field3) — int(3)
  • color (Field4) — char(10)
  • empnum (Key2) — char(10) — Foreign key → salesman.empnum — NOT NULL

producer (Untitled3)

  • producercode (Key) — char(16) — Primary key — NOT NULL
  • customercode (Field) — char(16)
  • style (Field2) — char(20)
  • color (Field3) — char(10)
  • size (Field4) — int(3)
  • inventory (Field5) — char(10)
  • customercode (Key2) — char(16) — Foreign key → customer.customercode — NOT NULL

salesman (Untitled2)

  • empnum (Key) — char(10) — Primary key — NOT NULL
  • salesamount (Field) — int(1000)
  • salesgoal (Field2) — int(1000)
  • salary (Field3) — char(7)
  • prod.code (Key2) — char(16) — Foreign key → shoes.prod.code — NOT NULL

shoes (Untitled)

  • prod.code (Key) — char(16) — Primary key — NOT NULL
  • style (Field) — char(20)
  • size (Field2) — int(3)
  • color (Field3) — char(10)
  • salesamount (Field4) — int(1000)
  • producercode (Key2) — char(16) — Foreign key → producer.producercode — NOT NULL