ERD5

Tables (4)

Shoes (Untitled)

  • Shoes Id (Key) — Primary key — NOT NULL
  • shoe style (Field)
  • shoe size (Field2)
  • shoe color (Field3)
  • department (Field4)
  • customer Id (Key2) — Foreign key → customer.customer Id — NOT NULL
  • departmentId (Key3) — Foreign key → department.departmentId — NOT NULL

customer (Untitled3)

  • customer Id (Key) — Primary key — NOT NULL
  • customer name (Field)
  • customer address (Field2)
  • customer phone (Field3)
  • buying habits (Field4)
  • purchase date (Field5)
  • purchase quantity (Field6)
  • departmentId (Key2) — Foreign key → department.departmentId — NOT NULL

department (Untitled4)

  • departmentId (Key) — Primary key — NOT NULL
  • employee Id (Field)
  • shoe stock (Field2)

supplier (Untitled2)

  • supplier Id (Key) — Primary key — NOT NULL
  • Shoes (Field)
  • department (Field2)
  • departmentId (Key2) — Foreign key → department.departmentId — NOT NULL
  • Shoes Id (Key3) — Foreign key → Shoes.Shoes Id — NOT NULL