SEPTEMBER 2024
School Club Management System
Description
A comprehensive desktop application designed to streamline the administration of school clubs. It handles member registration, event scheduling, attendance tracking, and resource allocation. Built with C# and WinForms, it features a robust backend database connection.
Mistakes & Challenges
Designing a normalized database schema that could handle complex many-to-many relationships (like students belonging to multiple clubs) was initially challenging. Early versions suffered from data redundancy and slow query performance when generating reports.
Output & Solution
The final system implements a clean 3NF database design and uses parameterized queries for security. The UI was refined to be intuitive for non-technical staff, reducing administrative time by approximately 40%.