Room Reservation System

Short description:

The Room Reservation System is a database-oriented project that focuses on the design and implementation of a relational database for managing reservations of shared rooms such as classrooms, offices, and meeting spaces. The database will store structured information about rooms, including their identifiers, locations, capacities, and equipment, as well as users who are allowed to make reservations. Additionally, the system will manage reservation records containing dates, time intervals, and the association between users and rooms.

The project emphasizes data integrity and consistency by applying appropriate primary keys, foreign keys, and integrity constraints to prevent invalid or overlapping reservations. The database will support different user roles, such as regular users who can search for available rooms and create reservations, and administrators who can manage room data and oversee reservations.

If the project is extended beyond the core database implementation, it could be integrated with a user interface or a web application that allows users to interact with the reservation system more intuitively. However, the main goal of this project is to demonstrate solid database design principles, normalization, and effective SQL usage rather than full application development.

Team members:

• Nikola Sarafimov 223091

Course: Databases in 2025/2026/Winter

Under the supervision of: ​Prof. Dr. Vangel V. Ajanovski

Content:

Phase	Link	Status
P0	About	Completed
P1	ERModel	In progress
P2	RelationalDesign	Not started
P3	UseCaseModel	Not started
P4	PrototypeImplementation	Not started
P5	Normalization	Not started
P6	Reports	Not started
P7	AdvancedDB	Not started
P8	Transactions	Not started
P9	Performance	Not started