exercise5

Tables (6)

customer (Untitled4)

  • code (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • phone (Field3)
  • purchasetype (Field4)

department (Untitled)

  • code (Key) — Foreign key → shoes.code — NOT NULL
  • quantity (Field)
  • buydate (Field2)
  • amount (Field3)
  • fees (Field4)
  • goal (Field5)

employee (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • salary (Field)
  • code (Key2) — Foreign key → department.code — NOT NULL

provider (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • code (Key2) — Foreign key → customer.code — NOT NULL

provider-shoestype (Untitled5)

  • id (Key) — Foreign key → provider.id — NOT NULL
  • code (Key2) — Foreign key → shoes.code — NOT NULL

shoes (Untitled2)

  • code (Key) — Primary key — NOT NULL
  • stock (Field)
  • style (Field2)
  • size (Field3)