HMS was introduced to solve the complications arising from managing all the paperwork of every patient associated with the various departments of hospitalization with confidentiality. HMS provides the ability to track and record all the paperwork in one place, reducing manual effort in arranging and analyzing the patients' paperwork.
This is Database of Hospital which has following modules:
-
Patient Management
-
Employee Management
-
Inventory Management
-
Stored Procedures-(Max_Disease_Occurence,Update_Room_Status,Employee_Bonus,Employee_Salary_Range)
-
Stored Functions- (Patient_room_Category,Patient_discounted_bill,Patient_age_category)
-
Views - (Patient_ordinary_data,Patient_sensitive_Data,Employee_sensitive_Data)
-
Triggers - (Check_quantity,Archive_Donor_patient,Monitor_oxygen_level, Monitor_heart_level)
-
Database - MySQL
-
Tool - MySQL Workbench