healthcare-management-system
说明： Healthcare Management System是一个数据库，旨在获取与医疗保健中心相关联的多个实体...
(Healthcare Management System is a database designed to get multiple entities associated with a healthcare center under a centralized database for efficient use of data)
(Healthcare Management System is a database designed to get multiple entities associated with a healthcare center under a centralized database for efficient use of data)
文件列表:
images (0, 2021-06-21)
images\EER.png (93575, 2021-06-21)
images\project-theme.png (457817, 2021-06-21)
images\viz1.png (33333, 2021-06-21)
images\viz2.png (76501, 2021-06-21)
images\viz3.png (87828, 2021-06-21)
images\viz4.png (82079, 2021-06-21)
images\viz5.png (67480, 2021-06-21)
scripts (0, 2021-06-21)
scripts\HealthCare(DDL).sql (4932, 2021-06-21)
scripts\HealthCare(DML).sql (11605, 2021-06-21)
scripts\HealthCare(Programmability).sql (6867, 2021-06-21)
visualization (0, 2021-06-21)
visualization\visualization.pbix (197389, 2021-06-21)
images\EER.png (93575, 2021-06-21)
images\project-theme.png (457817, 2021-06-21)
images\viz1.png (33333, 2021-06-21)
images\viz2.png (76501, 2021-06-21)
images\viz3.png (87828, 2021-06-21)
images\viz4.png (82079, 2021-06-21)
images\viz5.png (67480, 2021-06-21)
scripts (0, 2021-06-21)
scripts\HealthCare(DDL).sql (4932, 2021-06-21)
scripts\HealthCare(DML).sql (11605, 2021-06-21)
scripts\HealthCare(Programmability).sql (6867, 2021-06-21)
visualization (0, 2021-06-21)
visualization\visualization.pbix (197389, 2021-06-21)
# 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
### 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 近期下载者：
相关文件：
收藏者：