exercise5

Tables (6)

CUSTOMER (Untitled5)

  • customerId (Key) — char(5) — Primary key — NOT NULL
  • customerName (Field) — char(30)
  • customerAddress (Field2) — text
  • customerPhone (Field3) — char(11)

SALESMAN (Untitled6)

  • employeeNumber (Key) — char(5) — Primary key — NOT NULL
  • salesCommission (Field) — float(2.1)
  • salesQuota (Field2) — char(5)

SHOESLIST (Untitled2)

  • shoesProductCode (Key) — char(5) — Primary key — NOT NULL
  • deliveryDate (Field) — date
  • availableStock (Field3) — int(5)

SUPPLIER (Untitled)

  • supplierId (Key) — char(5) — Primary key — NOT NULL
  • supplydata (Field) — date

ShoesSales (Untitled4)

  • buyingHabitsType (Field) — char(1)
  • salesDate (Field2) — date
  • salesQuantity (Field3) — char(3)
  • transactionType (Field4) — char(1)
  • customerId (Key) — char(5) — Foreign key → CUSTOMER.customerId — NOT NULL
  • shoesProductCode (Key2) — char(5) — Foreign key → SHOESLIST.shoesProductCode — NOT NULL
  • employeeNumber (Key3) — char(5) — Foreign key → SALESMAN.employeeNumber — NOT NULL

ShoesSupply (Untitled3)

  • shoesStyle (Field) — char(10)
  • shoesSize (Field2) — char(3)
  • shoesColor (Key) — char(10) — NOT NULL
  • shoesamount (Field3) — int(5)
  • supplierId (Key2) — char(5) — Foreign key → SUPPLIER.supplierId — NOT NULL
  • shoesProductCode (Key3) — char(5) — Foreign key → SHOESLIST.shoesProductCode — NOT NULL