1️⃣ Objective
The objective of this capstone is to design, develop, and implement a comprehensive Hospital Management System (HMS). This web-based platform will serve as a central system for managing crucial hospital operations, including Patient Records (EHR), appointment scheduling, billing, and staff management, aiming to improve administrative efficiency, reduce human error, and enhance patient care coordination.
Key Goals:
✨ Develop secure Patient Registration and EHR modules adhering to basic data privacy principles (e.g., mock HIPAA/GDPR compliance).
✨ Implement a dynamic Appointment Scheduling System for doctors and departments, including availability tracking.
✨ Create a Billing and Inventory Module for managing services rendered, generating invoices, and tracking pharmaceutical stock.
✨ Design role-based access control for different user types (Admin, Doctor, Receptionist, Patient).
✨ Provide a Reporting Dashboard for administrators to monitor hospital performance metrics (e.g., patient turnover, revenue).
2️⃣ Problem Statement
Many small to medium-sized hospitals and clinics still rely on inefficient, disjointed systems or manual, paper-based processes for critical functions like patient record-keeping, billing, and scheduling. This leads to long wait times, data redundancy, difficulties in tracking medication and inventory, and a high risk of medication and administrative errors.
This project addresses the fragmentation and inefficiency by consolidating all core operational data and workflows into a single, integrated digital platform. The HMS will provide a secure, real-time environment, ensuring that staff have immediate access to accurate patient history, appointments, and billing information, thereby improving throughput and data security.
3️⃣ Methodology
The project will be developed using an agile approach, focusing on modular development for clear separation of concerns:
✨ Phase 1 — Foundation & Authentication: Set up the database schema and implement a secure user authentication system with clear role definitions (Admin, Doctor, etc.).
✨ Phase 2 — Patient and EHR Module: Develop forms for patient registration and modules for securely viewing, creating, and updating patient medical history (diagnoses, prescriptions, notes).
✨ Phase 3 — Scheduling Module: Implement complex scheduling logic, allowing patients to book appointments, doctors to manage their availability, and receptionists to handle walk-ins and cancellations.
✨ Phase 4 — Billing & Inventory: Create a module that automatically generates a bill based on services rendered in the EHR, and a separate module for tracking pharmaceutical stock and expiry dates.
✨ Phase 5 — Testing & Deployment: Conduct unit and integration testing. Deploy the finalized application in a secure, containerized environment (Docker).
4️⃣ Dataset
Core Entities:
✨ Patients: Demographic data, contact info, unique medical ID.
✨ Staff: Login credentials, role (Doctor, Nurse, Admin), specialty/department.
✨ Appointments: Patient ID, Doctor ID, Date/Time, Status (Scheduled, Completed, Cancelled).
✨ Medical Records: Diagnosis (ICD-10 code mock), Prescriptions, Vitals, Notes (linked to Patient ID and Doctor ID).
Patient Records Table (Sample):
5️⃣ Tools and Technologies
6️⃣ Evaluation Metrics
✨ Data Retrieval Latency: Time taken to fetch a complete patient record (Target: < 500ms).
✨ Appointment Slot Accuracy: Percentage of successful bookings without double-booking errors.
✨ Invoice Generation Time: Speed of generating a final bill from a completed visit record.
✨ Security Compliance: Successful implementation of role-based access control (RBAC) preventing unauthorized data access.
✨ Inventory Stock Accuracy: Measure of real-time inventory count vs. physical count (for drugs/supplies).
✨ User Adoption Rate: Feedback from test users (mock staff) on system usability and efficiency gains.
7️⃣ Deliverables
8️⃣ System Architecture Diagram
Staff Applications (Python Frontend)
Doctor, Nurse, Admin interfaces for patient charting and resource management.
Patient Portal (Web/Mobile)
Appointment booking, lab result viewing, billing access.
External Systems & Devices
Lab/Radiology Information Systems (LIS/RIS), Insurance/Claims APIs.
API Gateway / Security Layer
Enforces access control (HIPAA/GDPR compliance) and request routing.
EHR Service (Electronic Health Record)
Core service for storing, retrieving, and updating patient medical histories.
Appointment & Resource Service
Manages staff schedules, room/equipment allocation, and booking logic.
Primary Clinical Database (PostgreSQL)
Stores structured patient data, diagnoses, prescriptions, and historical appointments.
Messaging & Alert System
Delivers real-time lab result alerts and appointment reminders (SMS/Email).
Billing & Claims Processing
Generates invoices, tracks payments, and submits electronic insurance claims.
Final Outcome: Streamlined Operations, Enhanced Patient Care & Regulatory Compliance
Centralized data management leading to faster diagnosis and efficient resource utilization.
Staff Applications (Doctor/Nurse)
Doctor, Nurse, Admin interfaces for patient charting and resource management.
Patient Portal (Web/Mobile)
Appointment booking, lab result viewing, billing access.
External Systems & Devices
Lab/Radiology Information Systems (LIS/RIS), Insurance/Claims APIs.
2. Logic, Routing, and Processing
API Gateway / Security Layer
Enforces access control (HIPAA compliance) and request routing.
EHR Service (Electronic Health Record)
Core service for storing and updating patient medical histories.
Appointment & Resource Service
Manages staff schedules, room allocation, and booking logic.
3. Storage and Communication
Primary Clinical Database (PostgreSQL)
Stores structured patient data, diagnoses, and prescriptions.
Messaging & Alert System
Delivers real-time lab alerts and appointment reminders.
Billing & Claims Processing
Generates invoices and submits insurance claims.
Final Outcome: Streamlined Operations & Enhanced Care
Centralized data management leading to faster diagnosis and efficient utilization.
9️⃣ Expected Outcome
✨ A fully functional, integrated Hospital Management System that manages patient flow and core administrative tasks.
✨ Demonstrable improvement in operational efficiency through automated scheduling and billing.
✨ A secure system employing role-based access control to protect sensitive patient information.
✨ A modular codebase and robust deployment environment (Docker) for ease of future maintenance.