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 and related equipment. The system is intended for environments such as faculties, offices, laboratories, and meeting spaces where rooms and equipment need to be reserved in an organized and controlled way.

The database will store structured information about buildings, rooms, equipment, users, reservations, and approval decisions. Rooms are described by their identifiers, room codes, capacities, and types. Equipment can be available as general stock or assigned to specific rooms in specific quantities. Users are represented with different roles, including regular users who can create reservation requests and users with approval privileges who can approve or reject pending reservations.

The system will manage reservation records containing dates, start times, end times, reservation statuses, optional room selection, optional requested equipment, and approval information. A reservation may include a room, requested equipment, or both. This allows the model to support room-only reservations, equipment-only reservations, and combined room-and-equipment reservations.

The project emphasizes data integrity and consistency by applying appropriate keys, relationship mappings, and integrity constraints in the relational design. These constraints help prevent invalid data, enforce valid user roles and reservation statuses, and support the detection of overlapping reservations for the same room and time interval.

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, correct ER-to-relational transformation, 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	Approved
P1	ERModel	Approved
P2	RelationalDesign	Approved
P3	UseCaseModel	Approved
P4	PrototypeImplementation	Approved
P5	Normalization	Completed
P6	AdvancedReports	Completed
P7	AdvancedDB	Completed
P8	AdvancedApplicationDevelopment	Completed
P9	Performance	Completed