The POS database must support the following subsystems: Invoicing, Inventory Management, Customer Management, and Employee Management.
1. Invoicing
Primary Key Invoice Number = INV0001
A. Order Type
B. Supplier
C. Cost
D. Order date
E. Date Received
2. Inventory Management
Primary Key Item Number = IT0001
A. Item name
B. Item cost
C. Item Price
D. Date received
E. Location in store
3. Customer management
Primary Key Customer Number = C0001
A. First Name
B. Last Name
C. Address number
D. Street name
E. Zip Code
F. Last purchase
G. Last purchase date
4. Employee management
Primary Key Employee Number = E0001
A. First name
B. Last Name
C. Address Number
D. Street name
E. Zip Code
F. Hire Date
G. Title
H. Salary