110 likes | 181 Vues
This system includes necessary data fields for employees, customers, items, and orders. It efficiently manages employee and customer information along with orders and items. Ensure smooth operations and data accuracy.
E N D
Required Data for EMPLOYEES • Employee name. • Employee number. • Address: • Zip. • City. • Start date.
Required Data for CUSTOMERS • Customer name. • Customer number. • Address: • Street. • Zip. • City. • Phone.
Required Data for Items • Item name. • Item number. • Quantity. • Price.
Required Data for ORDERS • Order number. • Customer number. • Employee number. • Received Date. • Shipped Date. • Item number. • Quantity for each item in the order.