In a rapidly growing town in India, three government hospitals serve the majority of the population by offering affordable and accessible healthcare. However, patients often visit multiple hospitals depending on doctor availability, specialization, or treatment urgency — leading to fragmented records and inefficiencies in care delivery.
To address these challenges, this Centralized Multi-Hospital Patient Management System was designed as a relational database to:
- Provide unified access to patient medical histories across hospitals.
- Track diagnoses, prescriptions, appointments, and payments.
- Standardize hospital operations and departments.
- Offer data-driven insights for government healthcare policies.
- MySQL – For schema creation and querying
- ER Diagrams(Lucid Chart) – Conceptual and physical design
- Data Normalization – To reduce redundancy and ensure consistency
- Cross-Hospital Coordination – Shared doctor shifts, appointments, and patient histories
- Structured Reporting – Support for dashboards and analytics
- Centralized repository for patient info, diagnoses, and prescriptions
- Enables doctors to view complete patient history across hospitals
- Patients can book appointments with doctors in different hospitals
- Each appointment is tied to a transparent payment record
- Hospitals have standard departments (e.g., Cardiology, Pediatrics)
- Departments uniquely identified by
(hospital_id, department_id)
- Doctors work shifts across hospitals
- Shift data managed for better workload balance
- Records prescriptions per patient
- Supports efficient pharmacy inventory based on prescription trends
- Improved Patient Care :Doctors can access full medical history
- Consistent Records :Normalization prevents redundant data
- Fast Reporting :Standard schema for analytics
- Efficient Staffing :Shift tracking improves scheduling
- Better Policy Planning :Structured data supports decision-making