ex_5

Tables (4)

CUSTOMERS (Untitled2)

  • CustomerId (Key) — char(8) — Primary key — NOT NULL
  • ShoesCode (Key2) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • SupId (Key22) — char(6) — Foreign key → SHOES.SupId — NOT NULL
  • ShoesCode (Key222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • CustomerId (Key3) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • CustomerId (Key24) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • ShoesCode (Key223) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • SupId (Key2223) — char(6) — Foreign key → SHOES.SupId — NOT NULL
  • ShoesCode (Key22223) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • CustomerId (Key33) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • SPId (Key4) — char(6) — Foreign key → SALESPERSON.SPId — NOT NULL
  • CustomerId (Key23) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
  • ShoesCode (Key224) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
  • SupId (Key2222) — char(6) — Foreign key → SALESPERSON.SupId — NOT NULL
  • ShoesCode (Key22222) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
  • CustomerId (Key32) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
  • CustomerNumber (Field) — char(6)
  • CustomerName (Field2) — char(4)
  • ChustomerAddress (Field3) — char(10)
  • CustomerPhoneNumber (Field4) — char(8)
  • CustomerBuyingHabits (Field5) — char(12)

SALESPERSON (Untitled4)

  • SPId (Key) — char(6) — Primary key — NOT NULL
  • CustomerId (Key2) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • ShoesCode (Key22) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • SupId (Key222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
  • ShoesCode (Key2222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • CustomerId (Key3) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • SPId (Key4) — char(6) — Foreign key → CUSTOMERS.SPId — NOT NULL
  • CustomerId (Key23) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • ShoesCode (Key224) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • SupId (Key22222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
  • ShoesCode (Key222222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • CustomerId (Key32) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • SalesCommission (Field) — char(4)
  • SalesDegree (Field2) — char(4)
  • SalesQuota (Field3) — char(8)

SHOES (Untitled)

  • ShoesCode (Key) — char(8) — Primary key — NOT NULL
  • SupId (Key2) — char(6) — Foreign key → SUPPLIER.SupId — NOT NULL
  • ShoesCode (Key22) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
  • CustomerId (Key3) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • ShoesCode (Key23) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • SupId (Key222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
  • ShoesCode (Key2222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • CustomerId (Key32) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • CustomerId (Key24) — char(8) — Foreign key → SUPPLIER.CustomerId — NOT NULL
  • ShoesCode (Key223) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
  • SupId (Key2223) — char(6) — Foreign key → SUPPLIER.SupId — NOT NULL
  • ShoesCode (Key22223) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
  • CustomerId (Key33) — char(8) — Foreign key → SUPPLIER.CustomerId — NOT NULL
  • SPId (Key4) — char(6) — Foreign key → CUSTOMERS.SPId — NOT NULL
  • CustomerId (Key232) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • ShoesCode (Key224) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • SupId (Key22222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
  • ShoesCode (Key222222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
  • CustomerId (Key322) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • ShoeStyle (Field) — char(10)
  • ShoeSize (Field2) — char(3)
  • ShoeColor (Field3) — char(6)

SUPPLIER (Untitled3)

  • SupId (Key) — char(6) — Primary key — NOT NULL
  • ShoesCode (Key2) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • SupId (Key22) — char(6) — Foreign key → SHOES.SupId — NOT NULL
  • ShoesCode (Key222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • CustomerId (Key3) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • ShoesCode (Key23) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • SupId (Key2222) — char(6) — Foreign key → SHOES.SupId — NOT NULL
  • ShoesCode (Key22222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • CustomerId (Key32) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • SPId (Key42) — char(6) — Foreign key → SHOES.SPId — NOT NULL
  • CustomerId (Key232) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • ShoesCode (Key224) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • SupId (Key222222) — char(6) — Foreign key → SHOES.SupId — NOT NULL
  • ShoesCode (Key2222222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
  • CustomerId (Key322) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
  • SPId (Key4) — char(6) — Foreign key → SALESPERSON.SPId — NOT NULL
  • CustomerId (Key24) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
  • ShoesCode (Key223) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
  • SupId (Key2223) — char(6) — Foreign key → SALESPERSON.SupId — NOT NULL
  • ShoesCode (Key22223) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
  • CustomerId (Key33) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL