Restaurant Management System (RMS)

Short description

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.

The project aims to develop an integrated application that allows restaurant staff to efficiently manage orders, track reservations, and monitor inventory in real time. By centralizing all operational data, the system reduces manual work, minimizes errors, and improves service speed. The application will also provide analytics and reporting features, enabling owners to make informed decisions based on sales trends and stock usage. Overall, this system is designed to enhance productivity, organization, and adaptability in restaurant environments of varying sizes.

Team members

• Aleksandar Angelevski - 231219
• Filip Hadjievski - 231034
• Andrej Hristovski - 231162

Course

Advanced Databases in 2025/2026/Summer

Under the supervision of: Prof. Dr. Goran Velinov Assistant Nenad Anchev

Content

Phase	Link	Status	Date
P0	AboutProject	/	/
P1	RelationalModel	/	/
P2	DatabaseCreation	/	/
P3	QueryOptimization	/	/
P4	DatabaseProgramming	/	/
P5	DatabaseCreation	/	/