Healthcare Management System

PROJECT DESCRIPTION

Healthcare center have multiple departments and each of them tend to maintain their own individual system for record maintenance. This architecture of system design leads to inefficient data sharing, lack data consistency, excessive program maintenance etc. In order to eliminate these problems, we have designed a centralised database for Healthcare management system to help healthcare providers collect, store, retrieve and exchange patient healthcare information more efficiently and enable better patient care.

---

Enhanced Entity-Relationship Diagram (EERD)

---

Project Structure

1. Scripts folder contains -
   1. HealthCare(DDL) - Script to create database and tables for the associated entities
   2. HealthCare(Programmability) - Script contains Stored Procedures, Views, Triggers, Encryption for SSN, Non-clustered Index of the database
   3. HealthCare(DML) - Script adds mock data into the database
2. Visualization folder contains Dashboards designed using Power BI

---

Visualization

1. Count of patients for each Doctor
2. Count of patients associated with each Insurance company
3. Diagnosis
4. Medicine Usage
5. Financial Transactions

---

LANGUAGE AND TOOLS

• TSQL
• Microsoft SQL Server
• Power BI

INSTALL AND EXECUTE

• Install Microsoft SQL Server
• Import HealthCare(DDL).sql and execute the script to create database and tables
• Import HealthCare(DML).sql and execute the script to add mock data
• Import HealthCare(Programmability).sql and execute the script to create Stored Procedures, Views, Triggers, Encryption for SSN, Non-clustered Index of the database
• Install Power BI
• Connect to database and open the visualization.pbix to view dashboards