Hospital Management System
2 Group Member
Mitulkumar Limbasiya
Krunal Kotadia
Monak Shah
Manmay Barot
Rahul Rajput
Alap Desai
Ripal patel
DMIT_Project_Group_1_NPU_Fremont
3 Outline
About
Module
ER Diagram
Table Structure
Conclusion
DMIT_Project_Group_1_NPU_Fremont
4 Hospital Management System
Hospital Management System as name suggests will help us in
managing all hospital services by just using this system.
Every task of a hospital starting from filling a form of a patient,
allocating a doctor to him, charging his fee all sort of things till the
patient checks himself out.
DMIT_Project_Group_1_NPU_Fremont
5 Module
1. Patient
2. Patient Medical Details
3. Doctor
4. Staff
5. Payment
6. Disease
DMIT_Project_Group_1_NPU_Fremont
6 Patient
Every patient needs to register before meeting any doctor and thus he
needs to provide his basic information in order to fill up the form.
Basic Information may contain his name, email, residing address,
phone number and various such details.
DMIT_Project_Group_1_NPU_Fremont
7 Patient Medical Details
This part keeps the track of patient’s medical history & details.
It also includes about the part that keeps track of which doctor is
associated and appointed to which patient.
Patient’s disease, treatment done by doctor on patient, prescription
after treatment and also staff information associated with respective
patient.
DMIT_Project_Group_1_NPU_Fremont
8 Doctor
Doctors who belong to health care organization are kept in track with
their each and every information stored in this very module.
Information like doctors education, subject he mastered, contact
information and various such details.
DMIT_Project_Group_1_NPU_Fremont
9 Staff
This module is to keep track of all the staff member who are giving
their services to health organization.
Included information will be like staff members identification, his
contact information and with and under which doctor he is
associated.
DMIT_Project_Group_1_NPU_Fremont
10 Payment
Beginning from estimated cost of each surgery or treatment to the
billing of each patient is kept in this module.
It keeps the record of medical service bill payment, weather it is paid
or pending, amount to be paid, mode of payment and various such
billing regarding information.
DMIT_Project_Group_1_NPU_Fremont
11
ER Diagram
DMIT_Project_Group_1_NPU_Fremont
PatientMst DoctorMst
PK Patient_id PK Doc_id
Patient_name Doc_name
12
Patient_add Doc_degree
Patient_phone Doc_phone
Patient_email Doc_email
VistingTime
Doc_specialist
Payment
PatientMedicalDetails
PK PaymentId
PK Medical_id
Patient_id
Doc_id
Mode Staff
Patient_id
Amount PK Staff_id
Disease
Date Staff_name
Diagnoses
DueAmt Staff_type
Prescription
IsCritical Staff_email
Disease Staff_phone
NurseId
PK DiseaseCode
WardId
DiseaseName
DMIT_Project_Group_1_NPU_Fremont
IsLeathal
13
Table Structure
DMIT_Project_Group_1_NPU_Fremont
14 DoctorMst
DMIT_Project_Group_1_NPU_Fremont
15 PatientMst
DMIT_Project_Group_1_NPU_Fremont
16 PatientMedicalDetails
DMIT_Project_Group_1_NPU_Fremont
17 Staff
DMIT_Project_Group_1_NPU_Fremont
18 Payment
DMIT_Project_Group_1_NPU_Fremont
19 Disease
DMIT_Project_Group_1_NPU_Fremont
20 Conclusion
Hereby we conclude that Hospital Management System will serve
for every Health Organization for their betterment and improve
the quality of service with less efforts as well as less sweat to be
shed.
DMIT_Project_Group_1_NPU_Fremont
21
DMIT_Project_Group_1_NPU_Fremont