Design and Implementation of a Web-Based Medical Appointment Management System

Abstract

This paper presents the design and development of a comprehensive web-based Medical Appointment Management System (MAMS) aimed at addressing the operational inefficiencies of traditional manual scheduling in Libyan clinics. Existing systems predominantly rely on paper-based records and verbal coordination, leading to appointment conflicts, data loss, and poor patient experience. The proposed system automates the full appointment lifecycle—from booking to invoice generation—using Microsoft ASP.NET Web Forms, C#, and SQL Server. It provides four interactive portals (Guest, Patient, Doctor, and Administrator) governed by a Role-Based Access Control (RBAC) framework. Rigorous system evaluation across 45 structured test cases confirmed system stability with a 100% test pass rate. The system completely eliminated double-booking conflicts (0.0% overlap rate) and achieved a 92.3% reduction in booking transaction duration (from ~10 minutes down to 42.5 seconds), while reducing administrative reporting retrieval time to 1.2 seconds. The system represents a quantifiable, statistically verified step toward digital transformation in small and medium-sized medical institutions.