College Semester Project

Hostel Management Semester Project.

An interactive presentation landing page for our college semester project. This webpage is designed and built exclusively to understand what this system's Python/Tkinter and MySQL database code does.

đŸ’ģ Try Student Panel 🛡ī¸ Try Warden Panel
Hostel Management Dashboard Illustration
Project Domain Hostel Administration
Course Context College Semester Submission
Proposed & Presented in 2025
Backend Stack Python (Tkinter) & MySQL
Interactive Showcase Feature Simulator Included

Under the Hood

How the native Python & MySQL codebase is structured to drive hostel operations

🐍

Python & Tkinter

Powers the graphical desktop client. Coordinates multi-threaded modules, user authentication, form validation, and reactive dashboards.

🗄ī¸

MySQL Database

Integrates structured tables for user profiles, transaction logs, and records. Uses transactional constraints for security and efficiency.

🔄

Auto Theme & Sync

Includes built-in dark/light mode filters, interactive calendars, status indicators, and notification engines.

Robust Relational Database

Our system is backed by a relational database schema mapped to manage student profiles, outpasses, warden alerts, and attendance tables. Here is how the SQL tables are configured in gd_hms.sql:

✔ī¸ Referential integrity via foreign key links
✔ī¸ Enum structures for Status parameters (P/A/L, Pending/Approved/Rejected)
✔ī¸ Optimized indexes on common search columns
🔑 users Primary Table
user_idINT PRIMARY KEY (AUTO)
usernameVARCHAR(50) UNIQUE
passwordVARCHAR(255)
roleENUM('warden', 'hosteller')
first_nameVARCHAR(50)
last_nameVARCHAR(50)
emailVARCHAR(100) UNIQUE
phone_numberVARCHAR(15)
hostel_nameVARCHAR(50)
room_numberVARCHAR(10)
DOBDATE
📅 attendance Records Table
idINT PRIMARY KEY (AUTO)
usernameVARCHAR(50) INDEX
dateDATE
statusENUM('P', 'A', 'L')
📤 outpass_requests Workflow Table
request_idINT PRIMARY KEY (AUTO)
user_idINT INDEX
start_dateDATE
end_dateDATE
reasonTEXT
statusENUM('Pending','Approved','Rejected')
request_dateDATETIME

Interactive System Simulator

Click, trigger, and explore the app workflows in real-time, matching our exact Python scripting behavior.

Hosteller Dashboard - John Doe
Tkinter Emulator v1.0.4
Hosteller Workspace June 2026

📋 Personal Information

First Name:...
Last Name:...
Email:...
Phone Number:...
Year of Study:...
Department:...
Hostel Name:...
Room Number:...

📅 Monthly Attendance Tracker

Selected Date: 2026-06-06

📤 Request Outpass

History Attendance Logs
Date Status
Outpass History
Dates Reason Request Date Status
Warden Administration Center Control Hub
0 Total Hostellers
0% Avg Attendance
0 Pending Outpasses
0 Birthdays Today

📤 Outpass Approvals (Pending)

🎂 Today's Birthday Alerts

🔍 Filter & Manage Hostellers

Total Hostellers Found: 0
ID Name Email Hostel Room Department Year

System Capabilities

Explore the full suite of functionalities supported by this Hostel Management application

Security

Secure Authentication

Login system with password-checking that distinguishes student workspaces from warden permissions.

Roster

Hosteller Registry

Comprehensive registry recording DOBs, emails, phone numbers, room details, and student departments.

Approvals

Outpass Audits

Enables wardens to check, approve, or reject student travel outpasses with full logs tracking.

Utility

Birthday Scan

Automatically triggers on load to scan users born on today's date and highlights birthday lists.

ℹī¸ Semester Project Notice: This webpage is constructed only to understand what this system does. It functions as a web-based presentation and interactive simulator of our Python & MySQL backend code.