Hospital Management System
Introduction
This project is developed to automate and streamline the day-to-day operations of a small-city hospital. Managing patient records, doctor schedules, billing, pharmacy stock, and diagnostic reports manually is time-consuming and error-prone — especially in a multi-department setup.
The Hospital Management System (HMS) replaces traditional paper-based processes with a centralized computerized solution. It covers the complete patient journey — from OPD registration and department consultation to pharmacy dispensing, X-ray reports, billing, and discharge — making hospital operations faster, more accurate, and easier to manage.
Objectives
- Centralize patient registration, medical history, and department-wise records.
- Automate OPD token generation and doctor appointment scheduling.
- Manage department-wise patient flow — OPD, Ortho, Gynaecology, Emergency.
- Handle pharmacy inventory, medicine stock, and dispensing records.
- Maintain X-Ray and diagnostic reports linked to patient profiles.
- Generate automated bills including consultation, pharmacy, and diagnostic charges.
- Manage doctor, nurse, and staff records with attendance and duty roster.
- Provide administrative reports: daily OPD count, bed occupancy, revenue summary.
- Eliminate manual paperwork and reduce human errors in record-keeping.
Departments Covered
Key Features
Patient Management
Department Operations
Pharmacy & Diagnostics
Administration & Billing
Tools & Technologies
Frontend
- HTML5 & CSS3
- JavaScript
- Bootstrap — Responsive UI
Backend
- PHP — Server-side logic
- MySQL — Database
- phpMyAdmin — DB management
Design & Documentation
- ERD — Entity Relationship Diagram
- DFD — Data Flow Diagram
- Use Case Diagrams
- MS Word — Documentation
Environment
- Visual Studio Code
- XAMPP (Local Testing)
- Hostinger (Live Hosting)
System Design
The system is designed using a 3-tier architecture: Presentation Layer (WinForms UI), Business Logic Layer (VB.NET), and Data Layer (SQL Server). ERD, DFD, and Use Case diagrams define the data structure and workflows.
Patient Journey Flow
↓
Prescription Issued → Pharmacy Dispensing → X-Ray / Tests
↓
IPD Admission → Bed Assignment → Discharge + Bill
Implementation Modules
| # | Module | Key Functions |
|---|---|---|
| 1 | Patient Module | Registration, unique ID generation, profile management, medical history. |
| 2 | OPD Module | Token system, doctor queue, consultation entry, prescription generation. |
| 3 | Orthopaedics Module | Case records, fracture notes, surgery scheduling, physiotherapy tracking. |
| 4 | Gynaecology Module | Antenatal/postnatal records, delivery details, appointment management. |
| 5 | Emergency Module | Emergency intake, triage priority, ambulance log, real-time bed availability. |
| 6 | IPD / Ward Module | Admission, bed allocation, ward transfer, discharge summary. |
| 7 | Pharmacy Module | Inventory management, stock alerts, expiry tracking, prescription-based dispensing, supplier records. |
| 8 | Radiology Module | X-Ray request tracking, report storage, radiologist notes linked to patient ID. |
| 9 | Billing Module | Auto bill generation combining OPD, pharmacy, diagnostic, and room charges. Payment records. |
| 10 | Staff Module | Doctor/nurse/staff records, attendance, duty roster, salary management. |
| 11 | Reports Module | Daily OPD count, bed occupancy, revenue summary, department-wise reports via Crystal Reports. |
Results & Discussion
The system successfully automates and centralizes hospital operations for a small-city multi-department setup. Key outcomes achieved:
- Patient registration and OPD token generation time reduced significantly.
- Accurate prescription-linked pharmacy dispensing eliminated manual errors.
- Real-time bed availability in Emergency reduced patient wait time.
- Integrated billing combining all department charges eliminated manual calculation errors.
- Stock alerts in Pharmacy prevented medicine shortages and expiry losses.
- Centralized patient history accessible across departments improved care coordination.
Testing & Results
| Test Case | Result | Remarks |
|---|---|---|
| Patient Registration & ID generation | ✓ Pass | Unique ID auto-generated correctly |
| OPD Token & Queue System | ✓ Pass | Tokens assigned in correct order |
| Department-wise Patient Entry | ✓ Pass | All 4 departments working correctly |
| Pharmacy Inventory & Stock Alert | ✓ Pass | Alert triggered below threshold |
| Prescription-based Dispensing | ✓ Pass | Stock deducted on dispensing |
| X-Ray Request & Report Linking | ✓ Pass | Report linked to correct patient ID |
| Bed Availability (Emergency) | ✓ Pass | Real-time status updated on admission |
| Automated Bill Generation | ✓ Pass | All charges combined accurately |
| Discharge Summary & IPD Records | ✓ Pass | Summary generated on discharge |
| Reports (Daily OPD, Revenue) | ✓ Pass | Crystal Reports generated correctly |
| Staff Attendance & Roster | ✓ Pass | Records saved and retrievable |
Limitations
- Single Location: Does not support multi-branch hospital setup currently.
- No Online Appointment: Patients cannot book appointments online — walk-in only.
- No Insurance Integration: Insurance/TPA billing not included in current version.
- Limited Diagnostics: Only X-Ray covered; lab tests (blood, urine, etc.) not yet included.
- No SMS/Email Alerts: Appointment reminders and notifications not implemented.
- No Mobile App: Only accessible via browser — no dedicated Android/iOS app.
Future Scope
- Web-based version for remote access from multiple departments simultaneously.
- Online patient appointment booking system.
- SMS and email notification for appointments and reports.
- Full laboratory module (blood tests, urine tests, reports).
- Insurance and TPA billing integration.
- Mobile app for doctors to view patient records on the go.
- Role-based access control for doctors, nurses, pharmacist, and admin.
- Integration with biometric attendance for staff.
- Data backup and disaster recovery system.
Conclusion & Next Steps
The Hospital Management System successfully automates and integrates the operations of a small-city multi-department hospital. It reduces manual paperwork, improves patient data accuracy, streamlines department-wise workflows, and generates reliable administrative reports.
The system is user-friendly, efficient, and handles the complete patient journey from registration to discharge. It provides a strong foundation for future enhancements — particularly web-based access, online appointment booking, and a full laboratory module — to make it suitable for growing hospital needs.