Room Reservation System

The Room Reservation System is a database-oriented application designed to manage reservations of rooms such as classrooms, offices, and meeting spaces. The system enables users to search for available rooms based on selected dates and time intervals and to create reservations while ensuring that scheduling conflicts are prevented.

The primary focus of the project is the design and implementation of a relational database. This includes conceptual data modeling, definition of entity relationships, enforcement of integrity constraints, and SQL-based data manipulation. The system supports multiple user roles, such as regular users and administrators, where administrators are responsible for managing rooms and reservations.

Course: Databases

Academic year: 2025/2026

Project type: Database-oriented system

Team: Individual project – Nikola Sarafimov

Phase	Description	Wiki Page	Status
P0	Project Definition	About	In progress
P1	Conceptual Model (ER)	ERModel	Not started
P2	Relational Design and SQL	RelationalDesign	Not started
P3	Application Scenarios	UseCaseModel	Not started
P4	Prototype Implementation	PrototypeImplementation	Not started
P5	Normalization	Normalization	Not started
P6	Complex Queries and Reports	Reports	Not started
P7	Advanced DB Features	AdvancedDB	Not started
P8	Transactions and Concurrency	Transactions	Not started
P9	Performance and Security	Performance	Not started