ERD Exercise05

Tables (6)

Customers (Untitled2)

  • CustomerCode (Key) — char(5) — Primary key — NOT NULL
  • Name (Field) — char(10)
  • Adress (Field2) — char(100)
  • PhoneNumber (Field3) — char)10)
  • UniqueCodeOfShoes (Key2) — char(5) — Foreign key → Shoes Store.UniqueCodeOfShoes — NOT NULL

Purchase Information (CopyOfUntitled2)

  • Customer Number (Key) — char(5) — Primary key — NOT NULL
  • Type of Purchase (Key2) — char(5) — Primary key — NOT NULL
  • Date of Purchase (Field) — char(8)
  • Quntity Purchased (Field2) — char(2)
  • Numbers (Key3) — char(5) — Foreign key → Customers.CustomerCode — NOT NULL
  • SalesCommission (Key4) — char(30) — Foreign key → SalesPerson.SalesCommission — NOT NULL
  • CustomerCode (Key5) — char(5) — Foreign key → Customers.CustomerCode — NOT NULL

SalesPerson (Untitled)

  • employeeNumber (Key3) — char(5) — Primary key — NOT NULL
  • SalesCommission (Key) — char(30) — Primary key — NOT NULL
  • Salary (Field) — char(30)
  • Customer Number (Key2) — char(5) — Foreign key → Purchase Information.Customer Number — NOT NULL
  • SalesQuota (Key22) — char(5) — Foreign key → Purchase Information.Type of Purchase — NOT NULL

Shoes Store (Untitled4)

  • UniqueCodeOfShoes (Key) — char(5) — Primary key — NOT NULL
  • SupplierCode (Key2) — char(5) — Foreign key → Shoes Supplier.SupplierCode — NOT NULL
  • SupplierNumber (Key3) — char(5) — NOT NULL
  • TypeOfShoes (Key4) — char(5) — NOT NULL

Shoes Supplier (Untitled3)

  • SupplierCode (Key) — char(5) — Primary key — NOT NULL
  • TypeOfShoe'sCode (Field) — char(5)
  • StoreNumber (Key2) — char(5) — NOT NULL
  • QuantityOfProduct (Field2) — char(5)
  • UniqueCodeOfShoes (Key3) — char(5) — Foreign key → Shoes Store.UniqueCodeOfShoes — NOT NULL

Type of Shoes (CopyOfUntitled)

  • UniqueCode (Key) — char(4) — Primary key — NOT NULL
  • ShoeColor (Field2) — char(5) — Primary key
  • ShoeSize (Key2) — char(3) — Primary key — NOT NULL
  • ShoeStyle (Field) — char(10)
  • QuntityOfStock (Field3) — char(5)
  • UniqueCodeOfShoes (Key3) — char(5) — Foreign key → Shoes Store.UniqueCodeOfShoes — NOT NULL