<p>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.</p>

<p>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.</p>

<p>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.<br /> &nbsp;</p>

<ul>

<li> <p>The database and application are intended to be owned and maintained by the faculty. The primary purpose is to provide a centralized system for managing shared resources that are used for teaching, research, and administrative activities for more efficient time planning and organization.</p> </li> <li> <p>The problems solved will be the next but not limited to:</p>

<ul>

<li> <p>Lack of&nbsp;information about resource availability</p> </li> <li> <p>Conflicting or overlapping reservations</p> </li> <li> <p>Limited insight into historical resource usage</p> </li> <li> <p>Difficulty in planning resource allocation based on actual demand</p> </li> <li> <p>Information about availability of resources students didn&#39;t even knew they could use.</p> </li>

</ul> </li> <li> <p>There will be three types of users in this system:</p>

<ul>

<li> <p><strong>Teaching staff</strong>&nbsp;-&nbsp;reserve resources for lectures, labs, and research</p> </li> <li> <p><strong>Students</strong>&nbsp;- view availability and access permitted resources</p> </li> <li> <p><strong>Faculty administrators</strong>&nbsp;-&nbsp;manage resources, approve reservations, and analyze usage data<br /> <br /> &nbsp;</p> </li>

</ul> </li> <li> <p>I am not aware of similar solutions that are actually in use for this type of system.</p> </li> <li> <p>The system is database-driven and for start a web app is going to be made to access and control it but in the future a mobile app is also a possibility if it gets wider usage.</p> </li>

</ul>