Changes between Version 1 and Version 2 of About
- Timestamp:
- 02/10/26 13:51:53 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
About
v1 v2 1 = = Project Overview ==1 = About: Room Reservation System = 2 2 3 The Room Reservation System is a database-oriented project developed as part of the Databases course. The goal of the project is to design and implement a relational database that supports the reservation of rooms such as classrooms, offices, and meeting spaces. The system allows users to reserve rooms for specific dates and time intervals while ensuring that overlapping reservations are not permitted. 3 '''Team members:''' 4 * Nikola Sarafimov 223091 4 5 5 The project primarily focuses on database design and data management rather than on the development of complex user interfaces. Emphasis is placed on correctness, consistency, and integrity of the stored data. 6 '''Short description:''' 6 7 7 == Problem Statement == 8 The Room Reservation System is a database-oriented project whose main goal is to design and implement a structured relational database for managing room reservations in an organization or institution. The database will store information about rooms, users, reservations, time intervals, and user roles. It will support core operations such as searching for available rooms, creating reservations, updating reservation data, and preventing overlapping bookings. 8 9 9 I n many organizations, room reservations are often handled manually or using loosely structured tools, which may result in scheduling conflicts, double bookings, and inefficient resource usage. Without a centralized database, it is difficult to accurately track room availability and reservation history.10 If the project were to be further developed, it would represent a complete room reservation management system that could be used by educational institutions, companies, or organizations that need to efficiently manage shared spaces such as classrooms, meeting rooms, or offices. The emphasis of the project is on correct database design, integrity constraints, consistency of data, and SQL-based data manipulation, rather than on complex user interface development. The system is designed to clearly separate responsibilities between different user roles and ensure reliable reservation management. 10 11 11 This project aims to address these issues by providing a structured and reliable database solution that enforces data integrity and supports efficient reservation management. 12 '''Detailed description of the project:''' 12 13 13 == System Users and Roles == 14 The Room Reservation System is intended to be owned and operated by an organization or institution, such as a university, company, or administrative body, that provides room reservation services to its employees, staff, or members. The organization is responsible for maintaining the database and offering the reservation functionality as an internal service. 14 15 15 The system supports the following user roles:16 The main problem addressed by this project is the inefficient and error-prone management of room reservations when handled manually or through unstructured tools. Such approaches often lead to scheduling conflicts, double bookings, and lack of transparency regarding room availability and reservation history. By introducing a centralized relational database, these issues are minimized through enforced constraints and structured data management. 16 17 17 * '''Regular Users''' – Users who can search for available rooms and create reservations for specific dates and time intervals. 18 * '''Administrators''' – Users responsible for managing rooms and overseeing reservations, including adding, modifying, and canceling reservations. 18 The system supports different types of users. Regular users can search for available rooms and create reservations for specific dates and time intervals. Administrators have extended privileges, including managing room information, overseeing reservations, and modifying or canceling existing reservations when necessary. 19 19 20 Each role has clearly defined permissions to ensure controlled access to system functionality.20 Although similar room reservation systems already exist, this project focuses specifically on demonstrating a clean and well-structured database design that follows academic principles of database normalization, integrity constraints, and transactional consistency. The solution is tailored for educational purposes and emphasizes correctness and clarity over feature complexity. 21 21 22 == Main Functionalities == 23 24 The main functionalities of the Room Reservation System include: 25 26 * Management of room information such as capacity and location. 27 * Searching for available rooms based on date and time. 28 * Creating reservations while preventing scheduling conflicts. 29 * Viewing and managing existing reservations. 30 * Administrative control over rooms and reservations. 31 32 == Project Scope == 33 34 The scope of this project is limited to the design and implementation of the database layer and database-driven application logic. The project does not aim to deliver a production-ready application, but rather to demonstrate correct database modeling, normalization, constraint definition, and SQL usage. 35 36 == Technologies and Tools == 37 38 The following technologies and tools will be used in the implementation of the project: 39 40 * PostgreSQL for relational database management. 41 * SQL for data definition and manipulation. 42 * Trac Wiki for project documentation. 43 * A simple prototype application (e.g., command-line interface) to demonstrate database interaction. 44 45 == Project Team == 46 47 This project is developed as an individual project by: 48 49 * Nikola Sarafimov 22 The system is designed as a database-oriented application and can serve as the backend for a web-based or desktop application. The primary focus, however, remains on the database layer and its proper design and implementation.
