ERP System for Hospital Management System

Dhwanipanjwani
4 min readOct 7, 2020

There is a large demand for web-applications nowadays so we are here with a ERP system for Hospital Management. In present time it is very much essential that we get solutions to get quick medical treatment. This will reduce the work for hospitals and will provide ease in the treatment of patients.

So, first of all let us see what is ERP system?

Enterprise resource planning (ERP) is a process used by companies to manage and integrate the important parts of their businesses. Many ERP software are used by companies because this software help them implement resource planning by integrating all of the processes needed to run their companies with a single system.

Why ERP system is needed?

ERP-system is needed because it can help organizations bring together all their disparate activities under a single integrated application. By using ERP-system they can also manage their data very easily.

Objective of this Project:

The objective of our project is to provide simplicity to the doctors, nurses as well as patients.

Methodology and working:

In this Web Application we have provided 5 services:

1. Patient Registration

2.Patient Information

3.Checkout

4.Room Information

5.Add Staff

6.View Checkout

First our project is start from login panel where user have to give their credential.

So, this is first page of our ERP system.

So here we have to select which service we want to use.

1.Patient Registration:

In this service we provide the facility for registration of new patients.so here we have to fill up all details about patient. at back end side we write a sql query so that it can add new patient info. to particular table in database.

2.Pateint Information:

Using patient information we can add, search or delete any information regarding the patients.by providing only patient id we can find all other information.

In this we can search, update and also can delete previous record.

3. Checkout:

This function provides the facility to retrieve information such as check-in date, check-out date, building, room no., room type and medicine price.

4.Room Information:

Using Room Information the hospital staff can get a clear idea of room types, available beds, price and status of that room.

5.Add Staff:

It can be used to add details of staff such as name, gender, position, salary, contact and address.

In which we can add new staff member information and also search any staff member information using staff id and also can update previously added record.

6.View Checkout:

Through this we can get information if the patient has checked out or not.

So, we have created sql database at backend for checkout, patient, room, staff.

We can observe that at some point this system helps hospital management to reduce their work load in some or other way. By making certain changes we can use it for different management systems.

Github link of my project:

--

--