HostelFix: A MySQL-Based Relational Database for Hostel Complaint and Maintenance Tracking
Hostel residents regularly encounter problems such as faulty fans, leaking taps and unreliable internet connections. In many hostels, these issues are reported verbally, entered in a register or sent as messages, making it difficult to track their assignment, priority and repair cost. HostelFix addresses this problem through a relational database developed using MySQL 8. The database contains seven tables designed to satisfy Third Normal Form (3NF), nine foreign keys, three UNIQUE constraints and ten CHECK constraints. Each maintenance job records the assigned staff member’s in-time and out-time, allowing the elapsed duration to be calculated using SQL. Two AFTER triggers, three stored procedures, one view and a transaction support job assignment and complaint closure. The implementation was tested using sample data consisting of five rooms, six students, eight complaints, five staff members, four maintenance jobs and two feedback records. Thirteen SQL queries and the database automation features were executed, and the expected status changes were observed. The evaluation is limited to sample data representing one hostel; the system has not been deployed in a live hostel, and its performance has not been benchmarked.
Authors
- Shreya Mane
- Lisha Khairnar
Institutions
- AISSMS Institute of Information Technology (IN)
Publication Details
- Journal
- Zenodo (CERN European Organization for Nuclear Research)
- Published
- 2026-11-17
- DOI
- https://doi.org/10.5281/zenodo.24310305
- Primary Topic
- Engineering and Information Technology
- Type
- preprint