excercise 5
Tables (7)
customer (Untitled4)
- unique customer number (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- phone (Field2) — char(11)
- unique supplier code (Key2) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL
department (Untitled2)
- lnventory amount (Key) — Primary key — NOT NULL
employee (Untitled6)
- employee number (Key) — char(10) — Primary key — NOT NULL
purchase (Untitled5)
- date (Key) — char(8) — Primary key — NOT NULL
- quantity (Field) — char(100)
- Field2
- unique supplier code (Key2) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL
- employee number (Key3) — char(10) — Foreign key → employee.employee number — NOT NULL
- sales commission (Key4) — char(10) — Foreign key → salary.sales commission — NOT NULL
salary (Untitled7)
- sales commission (Key) — char(10) — Primary key — NOT NULL
- sales quota (Field) — char(!0)
suppliers (Untitled3)
- unique supplier code (Key) — char(30) — Primary key — NOT NULL
- credit (Field) — char(30)
- cash (Field2) — char(20)
- style (Key2) — char(30) — Foreign key → unique product code.style — NOT NULL
unique product code (Untitled)
- style (Key) — char(30) — Primary key — NOT NULL
- size (Field) — char(5)
- color (Field2) — char(10)
- Field3
- lnventory amount (Key2) — Foreign key → department.lnventory amount — NOT NULL
- unique supplier code (Key3) — char(30) — Foreign key → suppliers.unique supplier code — NOT NULL