The Faculty Resource Reservation and Usage Analytics System

Short Description

The Faculty Resource Reservation and Usage Analytics System is a database-centered project aimed at organizing and managing shared resources within a faculty or academic institution. The database will store data related to physical and digital resources, users, reservations, availability intervals, and historical usage information.

The project focuses on designing a well-structured relational database that ensures data integrity, supports efficient querying, and enables analytical reporting. If the project were further developed, it would include a simple application layer that demonstrates how users interact with the database to reserve resources, check availability, analyze usage trends and also propose new resources that were not shared before to be shared now.

The system is intended to improve transparency, reduce scheduling conflicts, and support data-driven planning decisions. The main emphasis remains on database modeling, constraints, normalization, and advanced SQL queries, in alignment with the learning objectives of the Databases course.

Team Members

First Name	Last Name	Index
Teodor	Bogoeski	221511

Course: Databases in 2025/2026/Winter

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

Content

Phase	Link	Status
P0	About	Completed
P1	ERModel	Completed
P2	RelationalDesign	In Progress
P3	ApplicationScenarios	Not Started
P4	FirstPrototype	Not Started
P5	Normalization	Not Started
P6	ComplexReports	Not Started
P7	AdvancedDB	Not Started
P8	AdvancedApp	Not Started
P9	OtherTopics	Not Started