Hospital Database Management System

Faysal Sarder
Department of CSE, City University
Dhaka, Bangladesh
Email: [email protected]

Abstract-My project Hospital Database Management • Information about Patients is done by just writing
system includes registration of patients, storing their the Patients name, age, and gender. Whenever the
disease details into the system. It will also contain Patient comes up his information is stored freshly.
doctor’s information and will digitalize the whole billing • Bills are generated by recording price for each
system. It has the facility to give a unique id for every facility provided to Patient on a separate sheet and
patient and stores the details of every patient and staff at last they all are summed up.
automatically. It includes a search facility to know the • Diagnosis information to patients is generally
current status of each room. User can search availability recorded on the document, which contains Patients
of a doctor and the details of a patient using the id. And information. It is destroyed after some time period
the whole process conducted by Administrator. to decrease the paper load in the office.
• Immunization records of the children are
Keywords- Hospital, Administrator, Patients, Doctor,
maintained in pre-formatted sheets, which are kept
Diseases, Staff, Treatments, Test, Lab reports, Schema. in a file.
• Information about various diseases is not kept as
1. BACKGROUND
any document. Doctors themselves do this job by
A Hospital Database Management System (HDMS) is a
remembering various medicines
computer or web based system that facilities managing the
All this work is done manually by the receptionist and
functioning of a hospital or any medical set up. This system
other operational staff and lot of papers are needed to be
will help in making the whole functioning paperless.
handled and taken care of. Doctors have to remember
The hospital database includes all the necessary patient
various medicines available for diagnosis and
data. The disease history, test results, prescribed
sometimes miss better alternatives as they can’t
treatment can be accessed by doctors without much delay in
order to make an accurate diagnosis and monitor the remember them at that time.
patient's health. It enables lower risks of mistakes.
A hospital is a place where Patients come up for general 2. IDEAS
diseases. Hospitals Provide facilities like: The hospital database includes all the necessary patient
data. The disease history, lab reports, prescribed
• Consultation by Doctors on Diseases. treatment can be accessed by doctors without much delay in
• Diagnosis for diseases. order to make an accurate diagnosis and monitor the patient's
• Providing treatment facility. health. It enables lower risks of mistakes.
• Facility for admitting Patients (providing beds,  The project maintains two levels of users:
nursing, medicines etc.) • Administrator.
• Immunization for Patients/Children. • User Level-Data Entry Operator.
Various operational works that are done in a Hospital are:  Now, I discuss the main facilities in this project are:
• Maintaining records of indoor/outdoor patients.
• Recording information about the Patients that
• Maintaining patient’s test and examinations details.
come.
• Providing different test facilities to a Doctor for
• Generating bills.
doctor for diagnosis of a patients.
• Recording information related to diagnosis given to
• Maintaining patient’s prescription, medicine and
Patients.
diet advice details.
• Keeping record of the Immunization provided to
• Providing billing details for indoor/outdoor
Children/Patients.
patients.
• Keeping information about various diseases and
• Results of tests, prescription, precautions and diet
medicines available to cure them.
advice will be automatically updated in the
These are the various jobs that need to be done in a
database.
Hospital by the operational staff and Doctors. All these
• In this project collection of data in form different
works are done on papers.
pathology labs.
The work is done as follows:
• Related test reports, patient’s details report, billing
reports can be generated as per user requirements.
• User or administrator can search a patient’s record  ER Diagram of Hospital Database Management System
by his id.
• Hospital Database Management System Design:
The Hospital database management system design is a
database design use for managing hospital functions
and events. It enables the admin to register a patient for
the hospital, stores their disease details into the
database. Any of the staff members, doctor & admin is
able to add, view, edit, update or delete data.
 Purpose of Hospital Database Management System:
The purpose of the Hospital Management
System database Design is to make a secure and easy
way of storing information of the patient, doctors,
inpatient, outpatient, Rooms, and Bill payment.
 Features of the Hospital Database Management System:
There are seven (8) common features of Hospital
Management System Database Design such as
Managing Administrator, Doctors, laboratory,
Inpatient, Outpatient, Rooms, and Hospital Bills
information.
• Administrator
This table of ER Diagram Hospital Management System
will be used for storing and managing the administrator
information. Administrator manage & maintain the whole
system.
• Manage Doctor
This table will be used for storing and managing the
Doctor information and login account.
• Manage Laboratory
This table will be used for storing and managing the The proposed ER diagram for Hospital DBMS with
Laboratory transaction. relationship shows the entity of the proposed Hospital
• Manage Inpatient Management system database, which is presented by tables;
This table will be used for storing and managing the tables are made to meet the required specification of the
the inpatient information and diagnosis. system and provide much more specific details of each entity
• Manage Outpatient within the system.
This table will be used for storing and managing Data Tables:
the inpatient information and diagnosis. 1. Administrator Table:
• Manage Room Fields Data Type Relationships
This table will be used for storing and managing
a_id int(5) Primary Key
the room information and assigning of patient in
a_name Varchar(20) Not Null
every room.
• Manage Bills gender Varchar(10) Not Null
The billing table will be used for managing the
statement of accounts per patient and for the 2. Doctor Table:
collection of bills.
• Manage Staff Fields Data Type Relationships
This table will be used for storing and managing Doctor_id int(5) Primary Key
the Staff information. Doctor_name Varchar(15) Not Null
Dept Varchar(15) Not Null
a_id Int(5) Foreign Key
3. Staff Table: 8. Bill Table:
Fields Data Type Relationships
Fields Data Type Relationships
s_name Varchar(15) Not Null
bill_no int(50) Primary Key
s_id Int(5) Primary Key
Patient_id int(5) Foreign Key
NID Int(12) Not Null
salary Int(5) Not Null patient_type Varchar(10) Allow Null
a_id Int(5) Foreign Key doctor_charge int Not Null
medicine_charge int Not Null
4. Lab table: room_charge int Not Null
Fields Data Type Relationships operation_charge int Allow Null

lab_no int(5) Primary Key number_of_days int Allow Null

Patient_id int(5) Not Null nursing_charge int Allow Null
weight int Not Null advance int Allow Null
Doctor_id int(5) Foreign Key health_card Varchar(50) Allow Null
date Date/Time[6] Not Null lab_charge int Allow Null

category Varchar(15) Not Null bill int Not Null

patient_type Varchar(15) Not Null

amount Int(10) Not Null Snapshot:
• Hospital DBMS Tables list in SQL Database
5. Inpatient Table: Server

Fields Data Type Relationships

Patient_id int(5) Primary Key
name Varchar(20) Not Null
gender Varchar(10) Not Null
address Varchar(20) Not Null
room_no int(5) Not Null
date_of_admit Date/Time[ 6] Not Null
date_of_discharge Date/Time[6 ] Not Null
advance Int(10) Not Null
• Hospital DBMS SQL Server Database Schema
lab_no int(5) Foreign Key Diagram
Doctor_id Int(5) Foreign Key

disease Varchar(20) Not Null

6. Outpatient Table:
Fields Data Type Relationships
Patient_id int(5) Primary Key
date Date/Time Not Null
lab_no int(5) Foreign Key

7. Room Table:

Fields Data Type Relationships

Insert data into all Tables:
room_no Int(5) Primary Key
Now, we can use insert statement for Insert (add) data or
room_type Varchar(10) Not Null record into tables.
status Varchar(10) Not Null • For Administrator table:
Patient_id Int(5) Foreign Key The statement below enters 2 records or rows into
patient table:
Table: Table:

• For bill Table:

The statement below enters 2 records or rows into
• For doctor table: bill table:
The statement below enters 2 records or rows into
doctor table:
Table:

• For staff Table:

Table: The statement below enters 2 records or rows into
staff table:

• For lab Table: Table:

The statement below enters 2 records or rows into
lab table:

Note: We will store this kind of record or information by

Table: using above process.

 Search a patient’s record by his id:

To see patient’s record, we will use select
• For inpatient table: statement.
The statement below enters 2 records or rows into I would like to see how much bill, doctor charge,
inpatient table: medicine charge, room charge, operation charge,
nursing charge are came and how much advance
given the first patient's

Table:

• For outpatient table:

The statement below enters 2 records or rows into
outpatient table:

3. Conclusion
The project Hospital Data Management System (MDBS) is
Table: for computerizing the working in a hospital. It takes care of
all the requirements of an average hospital and is capable to
provide easy and effective storage of information related to
patients that come up to the hospital. It generates test reports,
provide medicines prescribed to patient and doctor. It also
• For room table:
provides billing facility on the basis of patient’s status
The statement below enters 2 records or rows into whether it is an indoor or outdoor patient. The system also
room table: provide the facility of backup as per the requirement.
REFERENCES
[1] https://www.academia.edu/6880602/09_Project-
Hospital_management_system?email_work_card=thumbnail
[2] https://www.slideshare.net/EliasDinsa/hospital-management-system-
database-design
[3]https://www.academia.edu/29078722/Hospital_Management_System_
Design_and_Implementation?email_work_card=thumbnail