College Management System
A complete college ERP — Admin, Teacher, Student, Parent, Attendance, Live MCQs, and Fee panels, all on a role-based secure backend.
What the problem was
The entire college record was in registers and Excel files. Attendance was done manually, fee accounting was in a separate file, and parents only found out about their child\u2019s progress on result day. The biggest challenge was having four different kinds of users in one system — and each user should only see their own data.
What I built
I first created an ERD and normalized the MySQL schema — with clean relations between students, classes, subjects, teachers, attendance, fees, and exams. In Laravel, I applied role-based middleware to scope each panel\u2019s data separately. In the Live MCQs module, a teacher creates a test, the student attempts it with a timer, and the result is saved instantly. I also built REST APIs for the mobile app so attendance and results could be viewed on the phone.
Main parts of the system
Admin panel
Full control over students, teachers, classes, subjects, and fees, with dashboard stats.
Teacher panel
Mark attendance, create MCQ tests, and publish results.
Student panel
Attendance record, fee status, test attempts, and result history.
Parent panel
Child\u2019s attendance, fee, and result — all in one place, read-only access.
Attendance system
Date-wise marking, monthly percentage, and shortage alerts.
Live MCQs
Timer, auto-submit, instant scoring, and question bank.
Fee module
Challan generation, paid / unpaid status, and defaulter list.
REST API
Real-time data endpoints for the mobile app.
How it looks from the inside
