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