Reference no: EM13800802

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