Student Housing Management System
An integrated web system for managing student housing with an organized interface.
Project Summary
A web system designed to streamline student housing operations at educational institutions.
The Problem
Running student housing on a shared spreadsheet collapses quickly: the room is recorded twice, the student is assigned twice, and a request disappears between a message and a note. The problem is not the number of students but the absence of a single source of truth.
The system builds that source: rooms, students, allocation and requests in one data model with explicit relations.
Key Features
Room management
Add, edit, classify.
Student assignment
Auto/manual with history.
Requests
Maintenance and housing.
Dashboards
Occupancy overview.
Role-based access
Admin, staff, student.
Technical Challenges & Design Decisions
- Data integrity before UI: database-level constraints block conflicts (a student in two rooms, a bed occupied twice) before the interface ever has to warn the user.
- Built for non-technical staff: the user is a housing officer, not a developer. Every core action is completed from one screen with no intermediate steps.
- Real-world cases: transferring a student, vacating, rejecting then accepting a request — modelled as first-class flows, not exceptions.
Technical Architecture
Testing Methodology
- Tested conflict scenarios (double allocation, vacate-then-reassign) to confirm the system rejects invalid states.
- Reviewed the flow of core operations with a non-technical user.
Outcome & Impact
- One screen answers "who is in which room" with no manual matching.
- Conflicts prevented at the source instead of corrected afterwards.
- Seat allocation and requests in a documented flow.