Application Design - Use Cases and Database Access Scenarios - SQL Views

Actors

• User - The user is a person (or entity) who uses the application to make reservations and place orders. They can browse the offerings, conduct searches, and track their reservations and orders.

Example: A user who wants to book a table at a restaurant or place an online food order.

• Manager - The manager has extended permissions to administer the system. They can create/manage employee shifts, review reservations, generate reports, and make administrative decisions (such as adding new products, changing price lists, etc.).

Example: A person in a managerial role responsible for organizing and overseeing daily operations.

• Employee - The employee is part of the operational aspect of the system (e.g., waiter, cook, receptionist), and is responsible for carrying out user requests. They create bills, add ordered items to those bills, and ensure orders are properly fulfilled.

Example: A waiter who receives an order from a user and updates the bill.

Most Important Use Cases

Employee clocks in
Manager creates and assigns shift
Employee manages order
Employee transfers tab
Customer makes order
Customer makes reservation