This project is part of an end-of-course database project.
The goal was to design and implement a Hospital Management System (HMS) that can efficiently handle hospital operations such as patients, doctors, appointments, medical records, staff, and billing.
To extend functionality, an interactive Power BI dashboard was also created to provide insights into hospital performance and decision-making.
Develop a relational database and reporting solution to:
- Model hospital operations using an Entity-Relationship Diagram (ERD).
- Normalize data up to 3NF and implement it in SQL.
- Execute queries to manage and analyze patient and hospital records.
- Build a Power BI dashboard to visualize patient statistics, appointments, and revenue trends.
- Entities: Patients, Doctors, Appointments, Medical Records, Staff, Billing
- Normalization: All tables were normalized to Third Normal Form (3NF) to reduce redundancy.
- Schema & ERD: Designed using MySQL Workbench / draw.io.
(Insert ERD diagram here → (<img width="857" height="720" alt="image" src="https://github.com/user-attachments/assets/d02d1192-38fa-4c57-90de-206180321583" />)
- SQL (MySQL): Schema creation, data insertion, and queries
- Power BI: Interactive dashboards and reports
- Modeling Tools: MySQL Workbench / draw.io for ERD
The Power BI dashboard highlights:
- Sum of Paid by Doctor ID
- Sum of Paid by Email Adress
- Sum of Paid Canceld
- Sum of Paid by Year
(Insert dashboard screenshot here → (<img width="1844" height="747" alt="image" src="https://github.com/user-attachments/assets/2508c346-2560-4323-9471-0f18508d7853" />)
- Clone the repository:
git clone https://github.com/BassamKasar/Database-Project-Hospital-Management-System.git cd Database-Project-Hospital-Management-System