A Web-Based Automated Examination Management System Using Flask Framework and Lightweight Relational Database Architecture

Abstract: The rapid proliferation of digital infrastructure in educational institutions has necessitated a paradigm shift from conventional paper-based assessments toward automated, technology-driven examination platforms. This paper presents the design, implementation, and evaluation of a lightweight yet fully functional web-based examination management system developed using the Flask micro-framework in Python 3.11, a SQLite relational database, and a responsive front-end interface rendered through the Jinja2 templating engine. The proposed system encompasses a dual- role architecture supporting both student and administrative workflows. Students can register, authenticate, attempt a dynamically served multiple-choice examination, and immediately retrieve their evaluated results. Administrators are provided with a secured dashboard enabling complete lifecycle management of examination questions including creation, modification, and deletion as well as oversight of candidate performance records and the ability to reset individual examination attempts. The system enforces a single-attempt constraint per candidate through session-aware database integrity checks, mitigating examination malpractice. Deployment readiness is demonstrated through Gunicorn WSGI server integration and AWS CodeBuild compatibility via a structured buildspec.yml configuration. Empirical evaluation indicates a mean page response latency of 4.2 seconds under simulated load, with an average system usability score of 90 out of 100. The proposed architecture establishes a cost-effective, scalable, and pedagogically sound foundation for digital assessment, with prospective extensions including adaptive questioning, AI-driven proctoring, and multi-subject examination modules.

Keywords: web-based examination system, Flask framework, SQLite database, e-assessment, automated grading, educational technology, session management, WSGI deployment