ERD Exercise 5
Tables (8)
COMBINATION (Untitled2)
- combinationNumber (Key) — char(10) — Primary key — NOT NULL
- stock (Field) — char(10)
- styleCode (Key2) — char(10) — Foreign key → SHOESTYPE.styleCode — NOT NULL
- sizeCode (Key22) — char(10) — Foreign key → SHOESTYPE.sizeCode — NOT NULL
- productCode (Key3) — char(10) — Foreign key → SHOE.productCode — NOT NULL
- productCode (Key222) — char(10) — Foreign key → SHOE.productCode — NOT NULL
CUSTOMER (Untitled5)
- customerID (Key) — CHAR(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(40)
- phoneNumber (Field3) — char(13)
- purchaseType (Field4) — char(10)
PURCHASE (Untitled6)
- productCode (Key2) — char(10) — Foreign key → SHOE.productCode — NOT NULL
- productCode (Key22) — char(10) — Foreign key → SHOE.productCode — NOT NULL
- purchaseDate (Field) — char(10)
- purchaseQuantity (Field2) — char(10)
- customerID (Key) — CHAR(10) — Foreign key → CUSTOMER.customerID — NOT NULL
SAIE (Untitled8)
- productCode (Key) — char(10) — Foreign key → SHOE.productCode — NOT NULL
- enpoyeeNumber (Key2) — char(10) — Foreign key → SAIESPER.enpoyeeNumber — NOT NULL
- salesRate (Field) — char(10)
SAIESPER (Untitled7)
- enpoyeeNumber (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(40)
- phoneNumber (Field3) — char)13)
SHOE (Untitled)
- productCode (Key) — char(10) — Primary key — NOT NULL
- supplierCode (Key2) — char(10) — Foreign key → SUPPLIER.supplierCode — NOT NULL
- productCode (Key22) — char(10) — Foreign key → SUPPLIER.productCode — NOT NULL
SHOESTYPE (Untitled4)
- styleCode (Key) — char(10) — Primary key — NOT NULL
- sizeCode (Key2) — char(10) — Primary key — NOT NULL
- colorCode (Key3) — char(10) — Primary key — NOT NULL
SUPPLIER (Untitled3)
- supplierCode (Key) — char(10) — Primary key — NOT NULL
- productCode (Key2) — char(10) — Foreign key → SHOE.productCode — NOT NULL