Online Store Database

1. Online Store Database

2. Required Data for EMPLOYEES • Employee name. • Employee number. • Address: • Zip. • City. • Start date.

3. Required Data for CUSTOMERS • Customer name. • Customer number. • Address: • Street. • Zip. • City. • Phone.

4. Required Data for Items • Item name. • Item number. • Quantity. • Price.

5. Required Data for ORDERS • Order number. • Customer number. • Employee number. • Received Date. • Shipped Date. • Item number. • Quantity for each item in the order.

6. EMPLOYEEs Table

7. CUSTOMERs Table

8. Zip_code table

9. Items table

10. Orders table

11. ODETAILStable