George KhayatSoftware Engineer
← The ArchiveGK-003 — archive file

GK-003 · Academic · Desktop · Database

Student ManagementSystem

Records, enrollment and role-based access

A Java and MySQL desktop application for managing student records, enrollment, reporting, search, filtering and role-based access.

Year
2024
Status
Complete
Context
University project · American University of Science & Technology
Stack
Java · Java Swing · JDBC · MySQL · OOP
Recognition
1st Place — AUST Expo
01

Problem

Student records at small institutions are managed in spreadsheets — prone to errors, with no access control, no search and no audit trail for academic decisions.

02

What was built

A Java + MySQL platform with role-based access for admins, professors and students, enrollment workflows, grade management, attendance tracking, and search and filtering.

03

System

ClientJava Swing UIEdge / APIJDBCDataMySQLProcessRole-based sessionsProcessReports
Hover or tab through the nodes to trace each pathway.
  1. Stage 01
    • Java Swing UIAdmin · professor · student views
  2. Stage 02
    • JDBCDatabase access layer
  3. Stage 03
    • MySQLStudents, courses, enrollment, grades, attendance
  4. Stage 04
    • Role-based sessionsAccess control per role
  5. Stage 05
    • ReportsReport generation
Desktop UI → JDBC → MySQL → sessions → reports
04

Technical decisions

  1. D01

    Three roles, one system

    Admin, professor and student roles are enforced through role-based session management.

  2. D02

    Relational core

    Records live in MySQL and are accessed through JDBC from a Java Swing desktop interface.

  3. D03

    Built for the questions people ask

    Search, filtering and report generation sit on top of the enrollment, grade and attendance data.

05

Outcome

  • 1st Place at the AUST University Expo, awarded for its scalable role-based architecture and practical database design.
  • Demonstrated to university faculty and industry judges.