Student Management System
This desktop application streamlines the entire administrative lifecycle of an educational institute. Built with Java Swing and MySQL, it replaces manual record-keeping with a centralized digital system. The application features a user-friendly dashboard for managing student profiles, course modules, and fee structures, while providing administrators with real-time data on attendance percentages and payment statuses.
Key Features
- Interactive Dashboard: Visualizes system statistics for quick administrative decision-making.
- End-to-End Student Management: Handles registration, profile updates, and personal data archival.
- Dynamic Fee Tracking: Monitors payment status (Paid/Unpaid) and manages enrollment fees.
- Attendance Monitoring: Calculates and records attendance percentages per module.
- Automated Reporting: Generates summary reports for courses and student performance.
Technical Challenge
The main complexity lay in designing a normalized relational database schema to handle the many-to-many relationships between students, courses, and their respective modules. Early iterations suffered from data redundancy, particularly when tracking fee payments across different course durations. I resolved this by restructuring the MySQL database to Third Normal Form (3NF) and writing optimized JOIN queries to accurately calculate 'Paid/Unpaid' statuses dynamically without impacting application performance.
"Focusing on system optimization and clean data patterns."