Skip to content

Latest commit

 

History

History
56 lines (39 loc) · 2.49 KB

README.md

File metadata and controls

56 lines (39 loc) · 2.49 KB
Raw

Healthcare Management System

project

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)

EER

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 viz1
  2. Count of patients associated with each Insurance company viz2
  3. Diagnosis viz3
  4. Medicine Usage viz4
  5. Financial Transactions viz5

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