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