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