04/12/2023 1

Project: Hospital Management System

The Project work submitted to Mr.Shahzad khan Dept.CS UCS Shankar.

Submitted byIftikhar Ahmad (Roll No: 13)

iffi910@hotmail.com

MCS-II

In partial fulfillment of requirements for the course onDatabase Management System

For completion of 2nd Semester, MCS.

AWKUM (Mardan)June 06, 2014

04/12/2023 2

Introductiono Synopsis & Purpose:

• The Software is for the automation of a tiny Hospital Management.

• It can be used in any Hospital, Clinic or Dispensary for maintaining patient details and their results.

• The details gives the doctor, staffs details and patient details including doctor’s appointments and the billing system.

04/12/2023 3

Preliminary Study

SDLC

Planning

Analysis

Designo Logical Designo Physical Design

04/12/2023 4

Objective Analysis Admission:• Patient admit in hospital. Patient details:• Patient bio data. Doctors:• Doctors detail + appointment. Staff:• Nurse on duty & recptionist,accountant. Consultation:• Diagnosis treatment & medicine. Bill:• Billing of out patient.

04/12/2023 5

Output Result

• Patient diagnosis & test record.• Patient treatment result card.• Out patient bill deposit.• Patient discharge certificate.

04/12/2023 6

Project Requirements

Operating Systems:• Windows XP and above• Windows 7

Database:• SQL SERVER

S/W applications:• MS PowerPoint• Adobe Photoshop

04/12/2023 7

Logical Database Designing Entity Relationships

04/12/2023 8

Administrator

Staff

Patient

Process

HMSAuthenticate

Records(data)

Register, b

ill

Treatm

ent

Duty

Payroll

Context Diagram

04/12/2023 9

Patient

Doctor

Diagnosis

Staff

Accountant

ReceptionistLevel 0 Diagram

process5

Discharge

Register

Process1.1

Process2.1

Consultation

Process3.1

duty

Process2.2

medicineProcess3.1

Injection+Drip,diet

process4

Bill

Data store

admission entry

retrieve

appointment

obey

checkup

prescription

nurse

hire

prescribe

generate

pay

treat

clearance

registra

tion

disc

harg

e

assig

n

use

04/12/2023 10reg

Patient

Doctor

NurseReception

Diagnosis

Medicine

Accountant

Bill

billno

recpid

name

add

Pat_id

name

date

agetell#

name

name Drcode

gender

add

details

remarkdiano

Diareg

amount

company

Pat_name

price

regno

Empname

Emp_id

nameStf_id

designation

drnamedate

add

gender

Tell#

ER-Diagram

cure

Check up

pay

prescribe

buy

1ent

m

N

m

m

1

m

1

m

m1

m

1

add

add

company

04/12/2023 11

ER-2 Diagram

04/12/2023 12

Physical Database Designing

04/12/2023 13

Tables

The Database consists of 5 tables; patient, doctor, staff, diagnosis and bill. The ‘patient’ table consists of the basic data about the patient. ‘doctor’ consists of the information about doctor. The table ‘staff’ consists of the information regarding the staff(employee, nurse). ‘Diagnosis’ consists of data about the patient’s feverish. And finally, ‘bill’ table records the fee data of patient. In this way the entire billing system is integrated within a single database.

04/12/2023 14

04/12/2023 15

04/12/2023 16

Web Based Interface

04/12/2023 17

Conclusion

• The project Hospital Management System (HMS) is for computerizing the working in a hospital. The software 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 prescription details including various tests, check-up and medicines prescribed to patient and doctor. It also provides injection details and billing facility.

• The system also provides the facility of backup as per the requirement.

04/12/2023 18

best wishes ift kr