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

Institutions

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

HostelFix: A MySQL-Based Relational Database for Hostel Complaint and Maintenance Tracking

Shreya Mane, Lisha Khairnar
2 links
Zenodo (CERN European Organization for Nuclear Research)
Engineering and Information Technology
preprint

HostelFix: A MySQL-Based Relational Database for Hostel Complaint and Maintenance Tracking

Shreya Mane, Lisha Khairnar
preprint en

Abstract

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.

Zenodo (CERN European Organization for Nuclear Research)
AISSMS Institute of Information Technology (IN)
Engineering and Information Technology
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon