ONLINE STORE DATABASE
Data fields for managing employees, customers, items, and orders effectively. It streamlines the handling of employee and customer information while ensuring that all orders and items are accurately tracked. By utilizing this database management system, businesses can maintain smooth operations and enhance data accuracy, leading to improved customer service and operational efficiency. The design focuses on user-friendly navigation, making it accessible for staff who need to retrieve or update information quickly.
ONLINE STORE DATABASE
E N D
Presentation Transcript
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.
