| 10 | | == Course |
| 11 | | ** Advanced Databases in 2025/2026/Summer ** \\ \\ |
| 12 | | Under the supervision of: Prof. Dr. Goran Velinov Assistant Nenad Anchev |
| 13 | | == Content |
| 14 | | ||= Phase =||= Link =||= Status =||= Date =|| |
| 15 | | ||P0 || AboutProject || / || / || |
| 16 | | ||P1 || RelationalModel || / || / || |
| 17 | | ||P2 || DatabaseCreation || / || / || |
| 18 | | ||P3 || QueryOptimization || / || / || |
| 19 | | ||P4 || DatabaseProgramming || / || / || |
| 20 | | ||P5 || DatabaseCreation || / || / || |
| | 8 | == Short description |
| | 9 | The proposed system is a restaurant management platform supported by a structured database that stores and processes several types of data essential for daily operations. The database will include information about menu items (names, prices, ingredients, categories), customer orders (order details, timestamps, payment status), table reservations (date, time, number of guests, availability), and inventory records (stock levels, suppliers, purchase history). Additionally, it will maintain employee data (roles, schedules, access permissions) and configuration settings customized by the restaurant owner. |
| | 16 | The application will be owned and maintained by a company or software provider that offers it as a service (SaaS) to restaurants. The primary users are restaurant owners and managers who need a flexible tool to oversee operations, along with employees such as waiters, kitchen staff, and administrative personnel who interact with different parts of the system. |
| | 17 | |
| | 18 | This solution addresses common problems such as inefficient order handling, poor inventory tracking, and lack of coordination between staff. It improves accuracy, reduces waste, and enhances customer satisfaction. |
| | 19 | |
| | 20 | Users will include: |
| | 21 | * !Owners/Managers (full control and analytics) |
| | 22 | * Waitstaff (order entry and table management) |
| | 23 | * Kitchen staff (order tracking) |
| | 24 | * Administrative staff (inventory and reporting) |
| | 25 | |
| | 26 | Compared to existing solutions, this system emphasizes customization, allowing each restaurant to adapt workflows, menus, and features to their specific needs rather than using a rigid, one-size-fits-all platform. |
| | 27 | |
| | 28 | The application will primarily be a web-based system accessible through browsers, with optional mobile support for convenience and real-time updates on the go. |