INDEX

Sr. No Description Page No.

1 Introduction 3-12
1.1 Project profile 4
1.2 Problem Statement 6
1.3 Overview 7
1.4 Objectives 8
1.5 Goals 8
1.6 Modules 8
1.7 Functions 8
1.8 Module Description 9
1.9 Purpose 11
1.10 Abbreviations 12
2 Scopes & Planning 13-19
2.1 Scope 13
2.2 Assumptions and Dependencies 13
2.3 Feasibility Study 14
2.4 Software Engineering Model 17
5 References 19
3 Designing 20-56
3.1 Database Design 20
3.2 Data Flow Diagram 22
3.3 ER Diagram 30
3.4 Use Case Diagram 31
3.5 Snapshots 32 - 56
6 Conclusion 57
 Back to index

INTRODUCTION
Hospitality Service Provider System is an organized computerized system designed and
programmed to deal with day to day operations and management of the hospital
activities. The program can look after inpatients, outpatients, records, database
treatments, status illness, billings.

It also maintains hospital information such as patient id, doctors in charge and
department administering. The major problem for the patient nowadays to get report
after consultation, many hospital managing reports in their system but it's not available
to the patient when he / she is outside. In this project we are going to provide the extra
facility to store the report in the database and make available from anywhere in the
world.

The project Hospitality Service Provider System includes registration of patients, storing
their details into the system, and also computerized billing . The software has the facility
to give a unique id for every patient and stores the details of every patient and the staff.
It includes a search facility to search all the doctors, patients and appointments.

The Hospital Management System can be entered using a username and password. It is
accessible by an receptionist, doctor and the patient can register themselves on the
website. Only they can add data into the database. The data can be retrieved easily. The
interface is very user-friendly. The data are well protected for personal use and makes
the data processing very fast.

It is powerful, flexible, and easy to use and is designed and developed to deliver real
conceivable benefits to hospitals. It is designed for multispeciality hospitals, to cover a
wide range of hospital administration and management processes. It is an integrated
end-to- end Hospital Management System that provides relevant information across the
hospital to support effective decision making for patient care, hospital administration
and critical financial accounting, in a seamless flow.

Hospitality Service Provider System is a software product suite designed to improve the
quality and management of hospital management in the areas of clinical process
analysis and activity-based costing. Hospital Management System enables you to
develop your organization and improve its effectiveness and quality of work. Managing
the key processes efficiently is critical to the success of the hospital helps you manage
your processes.
 Back to index

PROJECT PROFILE

Project Title: DND HOSPITALS

Definition :
Hospitality Service Provider
System is an organized
computerized system designed
and programmed to deal with
day to day operations and
management of the hospital
activities. The program can
look after inpatients,
outpatients, records, database
treatments, status illness,
billings.
Developed For :

Project Guide(s):

Front End: Html, css ,Javascript

Scripting language : Php

Back End : Mysql

Operating System: Microsoft Windows 11

Designing Tools
 Back to index

Submitted By
 Back to index

PROBLEM STATEMENT

In this busy world we don’t have the time to wait in infamously long
hospital queues. The problem is, queuing at hospital is often managed
manually by administrative staff, then take a token there and then wait for
our turn then ask for the doctor and the most frustrating thing - we went
there by traveling a long distance and then we come to know the doctor is
on leave or the doctor can’t take appointments.

HMS will help us overcome all these problems because now patients can
book their appointments at home, they can check whether the doctor they
want to meet is available or not. Doctors can also confirm or decline
appointments, this help both patient and the doctor because if the doctor
declines’ appointment then patient will know this in advance and patient
will visit hospital only when the doctor confirms’ the appointment this will
save time and money of the patient.

Patients can also pay the doctor’s consultant fee online to save their time.
HMS is essential for all healthcare establishments, be it hospitals, nursing
homes, health clinics, rehabilitation centers, dispensaries, or clinics. The
main goal is to computerize all the details regarding the patient and the
hospital. The installation of this healthcare software results in
improvement in administrative functions and hence better patient care,
which is the prime focus of any healthcare unit.
 Back to index

OVERVIEW
Our application contains three modules – the admin module, the doctor module and the
patient module. Our application will not only help the admin to preview the monthly
and/or yearly data but it will also allow them to add, delete and view records. The admin
will be able to manage and delete information about doctors. Admin can view the
appointment list, prescription list, patients list, doctors list and feedbacks by the
patients.

In the doctor module the doctor can cancel appointments. The doctors can even add
prescriptions for their patients using our application. And then an email will be sent to
the patients when doctor cancels the appointment or prescribes the patient.

The patients will be able to apply for the appointment and make transaction for the
same, and can even cancel appointments with the doctors and will receive an email if
doctor cancels or prescribes the patient . Patients can add their feedbacks on the website
which will be visible by the admin.

ADVANTAGES

• The system automates the manual procedure of managing hospital

activities.

• Doctors can view their patients’ treatment records and details easily.

• It even generates an instant bill.

• The system is convenient and flexible to be used.

• It saves their time, efforts, money and resources.

DISADVANTAGES

• The admin has to manually keep updating the information by

entering the details in the system.

• Need Internet connection.

 Back to index

OBJECTIVES

• Appointments can be canceled by doctors and patients as well.

• Prescriptions by doctors to patients.

• Generation of Bill.

• Patients can change their password

GOALS

• User friendly

• Simple fast

• Low cost and effective

• It deals with the collection of patient’s information

MODULES

• Admin module

• Doctor module

• Patient module

FUNCTIONS

• Provide access to registered users only.

• Registration of new patients.
• Enable patient to view their record.
• Select appointment date and timing.

• Patients can do Payment

• Admin access to patient’s record.
• Generate Bill/Receipt
• Patients can change password
 Back to index

MODULE DESCRIPTION

ADMIN MODULE

Admin has the full access to the system which means he is able to manage any activity with regard to the
system. He is the highest privileged user who can access to the system.

Key functions:-

• Add doctors

• Delete doctors

• Watch appointments of doctor

• View doctors and patients list

• Keep a watch on prescriptions provided by doctors

• Keep a check on feedbacks

DOCTOR MODULE

Doctors can view the patient appointment list and provide the priscriptions if required. Doctors have
access to only records of those patients whom they are treating.

Key functions:-

• Manage appointments with patients

• Create prescriptions for patients
• Cancel appointments
 Back to index

PATIENT MODULE

Patients can choose the best preferred appointments from the options provided and can also change the
appointment schedule or cancel it. After appt. is confirmed by the respective doctor they can pay their
consultant fee online. Patients have access to only their records.

Key functions:-

• Make appointments
• View prescription details

• View doctors according to specializations

• View appointment history

• Cancel appointments
• Change password
 Back to index

PURPOSE

This software will help the company to be more efficient in registration of

their patients and manage appointments, records of patients. The purpose
of this project is to computerize all details regarding patient details and
hospital details.

• Less paper work

• Cost reduction
• Improves patients experience

• Improve data security

• Better collaboration & communication

• Easy access to patient data

 Back to index

ABBREVIATIONS

Cardiologist- heart specialist

Dermatologist- skin specialist

Neurologist- brain specialist

Obstetrician- specialist for pregnant women

Ophthalmologist- specializes in eye diseases

Pediatrician- specialist for babies and children

Psychiatrist- specialist in mental health

Infectious disease doctors- specialist in contagious diseases. Like- tuberculosis, pneumonia, HIV

Endocrinologists- specialist in endocrine system. Like- diabetes, thyroid conditions, hormone

imbalances

Gastroenterologists- focus on the digestive system.

Anesthesiologists- focus on a person’s well-being before, during, and after surger

Otolaryngologists- ear, nose, and throat (ENT) doctors.

Clinical Immunologist- Study on immune system

 Back to index

SCOPES AND PLANNING

SCOPE

The system will be used as the application that serves hospitals, clinic,
dispensaries or other health institutions. The intention of the system is to
increase the number of patients that can be treated and managed properly.
If the hospital management system is file based, management of the
hospital has to put much effort on securing the files. They can be easily
damaged by fire, insects and natural disasters. Also could be misplaced by
losing data and information.

ASSUMPTIONS AND DEPENDENCIES

• Each user must have a valid user id and password

• Server must be running for the system to function

• Users must log in to the system to access any record.

• Only the Administrator can delete records.

 Back to index

FEASIBILITY STUDY:

What is feasibility study?

• To understand the needs of the community

• Estimate the patient load the hospital can attract

• Establish the viability of the planned hospital

• Designing the services and its phase-wise roll-out

• Preparing the project plan

Basic feasibility criteria are:

• Technological

• Operational

• Economic

• Schedule

• Social

• Legal

Technological:

Technological criteria provide the most appropriate technical solutions to the

discovered problems. According to this hospital management system once we analyze
the requirements one thing is highlighted to use online system for managing the
hospital activities which will make things easier and faster.
 Back to index

Economic:

Economic is deciding the cost of the entire system. After analyzed the
requirements cost can estimate. While developing the management cost is not an exact
amount. Because sometimes processes can not finish on time, some errors may occur and
etc. Fluctuate of cost can be occur due to this reason.

• An estimated cost of the system can fulfill patient’s requirements

• Estimated cost is enough to finish the processes.

• Can do the processes without any other addition charges.

Operational:

This will check how the designed system performs in the real operational environment.
When we apply to this criteria there are some important questions may arise,

• How does the staff will feel about the new system?

• Do they contribute to the proposed system?

• The proposed solution may perform in good in the real environment or not?

Schedule:

This criteria model is parallel goes with the scheduled time. Ability of finish the tasks on
time is measured under this model. At the beginning of the system make the agreement.
After how many time periods client will get the product.
Customer’s satisfaction is more needed in this stage. The system development process will
meet the delivery deadline of seven months provided by the hospital management team.
 Back to index

Legal:

Most of the time this criteria model is depends on government rules. Once the product
finished it will check under the government. It will check what kinds of functions are
available in the system, are there any functionalities that not suitable and the product is
observance the rules and regulations of the government or not. At the end this
product hospital management system should registered under government. Then no one
can create the same system under their name.

Social:

People will talk about the system when it operates in real environment. Let’s think
according to this product it is in the top of world best hotel reservation system. Then
what will happen? Everyone will talk about this system and they also motivate to
apply this into their operation also. According to this system customer is one of the most
important part of their society. Management system should realize the user needs well.
 Back to index

SOFTWARE ENGINEERING MODEL :

Software engineering model used in our project is waterfall model, The Waterfall Model
was the first Process Model to be introduced. It is also referred to as a linear-sequential life
cycle model. It is very simple to understand and use. In a waterfall model, each phase must
be completed before the next phase can begin and there is no overlapping in the phases.
The sequential phases in Waterfall model are –

• Requirement Gathering and analysis − All possible requirements of the system to be

developed are captured in this phase and documented in a requirement specification
document.

• System Design − The requirement specifications from first phase are studied in this
phase and the system design is prepared. This system design helps in specifying hardware
and system requirements and helps in defining the overall system architecture.

• Implementation − With inputs from the system design, the system is first developed in
small programs called units, which are integrated in the next phase. Each unit is developed
and tested for its functionality, which is referred to as Unit Testing.

• Integration and Testing − All the units developed in the implementation phase are
integrated into a system after testing of each unit. Post integration the entire system is
tested for any faults and failures.
• Deployment of system − Once the functional and non-functional testing is done; the
product is deployed in the customer environment or released into the market.

• Maintenance − There are some issues which come up in the client environment.
To fix those issues, patches are released. Also to enhance the product some better
versions are released. Maintenance is done to deliver these changes in
the customer environment.
 Back to index

ADVANTAGES:

• Simple and easy to understand and use

• Easy to manage due to the rigidity of the model. Each phase has specific
deliverables and a review process.

• Phases are processed and completed one at a time.

• Works well for smaller projects where requirements are very well understood.

• Clearly defined stages.

• Well understood milestones.

• Easy to arrange tasks.

• Process and results are well documented.

DISADVANTAGES:

• High amounts of risk and uncertainty.

• Not a good model for complex and object-oriented projects.

• Poor model for long and ongoing projects.

• Not suitable for the projects where requirements are at a moderate to high risk of
changing. So, risk and uncertainty is high with this process model.

• It is difficult to measure progress within stages.

• Cannot accommodate changing requirements.

• Adjusting scope during the life cycle can end a project.

 Back to index

REFERENCES

[Link]

[Link]

[Link]

[Link]
 Back to index

DATABASE DESIGNS

Admin Table:

FIELD NAME DATA TYPE DESCRIPTION

Username Varchar Enter Username
Password Varchar Enter password

Appointment Table:

FIELD NAME DATA TYPE DESCRIPTION

Pid Int Patient id
Id Int Appointment id
Fname Varchar First name
Lname Varchar Last name
Gender Varchar Gender
Email Varchar Email
Contact Varchar Contact
Doctor Varchar Doctor name
Docfees Int Doctor fees
Appdate Date Appointment date
apptime Time Appointment time
Userstatus Int User’s status
doctorstatus Int Doctor’s status

Contact Table:

FIELD NAME DATA TYPE DESCRIPTION

Name Varchar Name
Email Text Enter email
Contact Varchar Enter contact no.
Message Varchar Enter message
 Back to index

Doctor Table:

FIELD NAME DATA TYPE DESCRIPTION

Username Varchar Username
Password Varchar Password
Email Varchar Email
Spec Varchar Specialization
Docfees Int Doctor fees

Patient Register Table:

FIELD NAME DATA TYPE DESCRIPTION

Pid Int Patient id
Fname Varchar First name
Lname Varchar Last name
Gender Varchar Gender
Email Varchar Email
Contact Varchar Contact no.
Password Varchar Password
Cpassword Varchar Confirm password
Resettoken Varchar Reset token
Resettokenexpired Date Reset token expired

Prescription Table:

FIELD NAME DATA TYPE DESCRIPTION

Doctor Varchar Doctor name
Pid Int Patient id
Id Int Appointment Id
Fname Varchar First name
Lname Varchar Last name
Appdate Date Appointment date
Apptime Time Appointment time
Disease Varchar Disease
Allergy Varchar Allergy
Prescription Varchar Prescription
 Back to index

DATA FLOW DIAGRAMS

0 LEVEL
 Back to index

LEVEL 1 DFD

ADMIN :
 Back to index

DOCTOR:
 Back to index

PATIENT:
 Back to index

DFD 2ND LEVEL

Admin side ( login ):

Admin side ( manage doctors ):

Admin side ( view appointment ):

 Back to index

Admin side ( view prescription ):

Admin side ( view feedback ):

Doctor side ( login ):

Doctor side ( manage appointment ):

 Back to index

Doctor side ( give prescription ):

Patient side ( registration ):

Patient side(login):

Patient side ( manage appointments ):

 Back to index

Patient side ( view prescription ):

Patient side ( send feedbacks ):

Patient side ( forgot password ):

 Back to index

ER DIAGRAM
 Back to index

USE CASE DIAGRAM

 Back to index

SNAPSHOTS

HOME PAGE:
 Back to index

ABOUT US:
 Back to index

PATIENT REGISTER PAGE:

 Back to index

PATIENT LOGIN PAGE:

 Back to index

FORGOT PASSWORD:
 Back to index

EMAIL SENT TO CHANGE PASSWORD:

 Back to index

UPDATE PASSWORD:
 Back to index

PATIENT SIDE DASHBOARD:

 Back to index

BOOK APPOINTMENT:
 Back to index

VIEW APPOINTMENT HISTORY:

 Back to index

CONTACT US:
 Back to index

EMAIL SENT TO PATIENT:

 Back to index

DOCTOR LOGIN PAGE:

 Back to index

DOCTOR SIDE DASHBOARD:

 Back to index

VIEW APPOINTMENTS: Inactive if date is in past

 Back to index

PRESCRIPTION LIST:
 Back to index

PRESCRIBE PATIENTS:
 Back to index

PRESCRIPTION SENT IN EMAIL:

 Back to index

APPPOINTMENT CANCELLED BY DOCTOR:

 Back to index

ADMIN LOGIN:
 Back to index

ADMIN SIDE DASHBOARD:

 Back to index

DOCTORS LIST:
 Back to index

PATIENTS LIST:
 Back to index

APPOINTMENT DETAILS:
 Back to index

PRESCRIPTIONS LIST:
 Back to index

ADD DOCTOR:
 Back to index

DELETE DOCTOR:
 Back to index

FEEDBACKS:
 Back to index

CONCLUSION

Hospital management system is all about the modernizing a hospital through use of
technology. Computers helps in it and take over the manual system for quick and easy
functioning. This hospital management system is a quite the reliable and is proven on
many stages. All the basic requirements of the hospital are provided in the hospital in
order to manage it perfectly and large amount of data can also be stored . It gives many
facilities like taking appointments, prescribing patients online, searching for the detail
of patients and doctors , as well as billing facilities. So it’s a important system for
modern days.