Hospital Management System Project

There are several other reasons that a person needs medical assistance. And, to provide the best medical assistance, the management of the hospital must be disciplined, well-versed in its service-providing techniques. They should be able to keep track of the records of the doctors, patients, nurses, and other hospital staff.

However, if these records are maintained on papers, it will not be a cup of tea that can be sipped without burning the lips. It is not very efficient, is not reliable, and is a very time-consuming process. In todays highly technological era, it is not feasible not also technically but also economically. So, your job is making an automated system for keeping the track of all the activities and maintaining their records.

This process is called Hospital Management System. Your main aim is to minimize the paperwork of the hospital as minimum as possible, if not completely.

This Hospital Management System should contain but not limited to some Key Features:

Multi-user account system

Appointment Management

View Appointments

Notifications

Medical History

Invoice Management

Medical Report Management

Entering into the System (registration)

Every single type of user will go through the initial phase i.e. registration in order to start with the system. The registration process will not be exactly the same for all types of users.

The following are the common requirement fields:

Name The user will be asked to enter his/her full name.

Password It is the key field that will help the user to have a secure account in the system.

Contact No. The concerned user should also provide his personal mobile number or residence contact number so that he/she can be contacted at the time of need.

Email ID Now, the email address has become the for the communication purpose, verifying the users involved in the system. It helps in making the authenticated system.

For every type of user there will be different view and different privileges of the system.

Edit Profile

It is another common feature of this management system. It is not possible to ask for all the important information from the user at the time of registration. This would make the difficult time for the user who is trying to create the account for the first time in the system. So, a user can enter his/her personal information anytime they want.

One of them is the address. It is mandatory for some future communications. It consists of the apartment number, area name, street name, city name, zip code, country name, etc.

The following are some additional information that needs to be updated:

Date of Birth.

Age.

Gender.

Height and Weight (For patients).

Profile Photo The user must upload his / her profile photo after the first login.

Designation (For Hospital staffs).

And, the users can update any of these fields or their contact numbers any time they want. Now, I have detailed all the common features for seven modules.

Let us get into the other different features of each module:

Receptionist

The receptionist will be the user that will keep tabs on the appointments. This user will maintain the timetable of each doctor. This timetable of each doctor will be available to the patients. The other task the receptionist can do is, filtering the appointments based on doctors and time periods so that it is easy to access the appointment record.

Accountant

An accountant is a user who deals with the financial transactions of the hospitals. All the payment information and invoices will be managed by the accountant.

Pharmacist

All the medicines and their information in the hospital are managed by the pharmacists. He/she can view which medicines are in the stocks and which are to be needed. He/she can filter the medicines based on date i.e. expired date so that it is easier to know which medicines are going to expire so that those can be arranged at the hour of the need.

When the patient provides the prescription to the pharmacist, the pharmacist can provide the appropriate medications to the concerned patient.

Patient

This is the user why a hospital management system is introduced. A patient can make an appointment with the available doctors. The timetable will be shown which is directed by the receptionist. When the doctor approves the appointment, the patient will be notified via SMS.

The patient can view the doctors report about his / her appointment and his / her prescription details. Thus, the patient can clearly know what has happened to him/her and how she or he should take care of herself or himself. If there are some serious health issues and the patient is needed to be admitted into the hospital, the bed would be allotted to him or her.

The patient can view the information about the allotted bed. The patient can also have a private massage session with the doctors.

Nurse

The nurse is an assistant to the doctor. The nurse helps the doctors in performing the operations. She takes the diagnostic report and provides it to the doctor.

Laboratories

Whenever a patient is asked by the doctor to have some tests, so that the doctor can prescribe some medications according to the test result, the patient goes to the lab. Their lab assistant diagnoses some tests and generates the reports. This report further is handed over to the nurses account.

Doctor

The doctor is the user who will help the patients with their physical health. The doctor will be able to approve the appointments whether he or she wants to take them or not.

If the doctor wants, he or she can cancel the appointments. The concerned patient will be notified via SMS.

The doctor can view the medication history of the patients. The doctor can provide prescriptions to the patients.

The doctor will be able to have a private conversation with the patients. There might be a chance when the patient needs medical assistance at home or anywhere but a hospital. So, I will provide a private massage room for the doctor and patient.

In this project you need to (but again not limited to):

- create a database schema call it HOSPITAL (in Oracle or MySQL).

- create the tables that you think are needed.

- draw the necessary forms.

- create the select as well as the insert statements to populate the tables and read from them using procedures and necessary functions.