Database Management

Entity Relationship Diagram for Restaurant Management

Target client: A restaurant

System users: Restaurant owner, employees

Optional Key Tasks: Inventory, Online orders, Phone orders, Deliveries, Points/Rewards System, Customer records, Billing, Employee tmesheets, Payroll

1. What are 5-7 entities and their attributes? List the requirements.

2. Use the requirements to draw an ER diagram.

3. Who are the intended end-users? What benefits does the organization obtain by implementing the system?

Entities can include: Cashiers, Bill, Customer, Restaurant, Manager, Order, Chef. Connect these entities to each other and list attributes that belong to each entity. Draw out the ER diagram.