CENTRAL BOARD OF SECONDARY EDUCATION
Tender Heart Senior Secondary School
Tupudana, Ranchi
BOARD FINAL TERM PROJECT REPORT FILE IS
SUBMITTED TO DEPARTMENT OF INFORMATION
TECHNOLOGY FOR THE PARTIAL FULLFILLMENT OF
AISSE EXAMINATION SESSION 2022-23.
SUBMITTED BY : Sneha Kiran
SUB-TEACHER : Prahlad BAraik
CLASS/SEC : X 'C'
ADM NO : 10100
ROLL NO : 57
SESSION : 2022-23
ACKNOWLEDGEMENT
I wish to express my deep sense of gratitude
and indebtedness to our Learned teacher
Prahlad Baraik, PGT COMPUTER SCIENCE,
Tender Heart Senior Secondary School for his
invaluable help, advice and guidance in the
preparation of this Project.
I am also greatly indebted to our Principal
Usha ma'am and School Authorities for
providing me with the facilities and requisite
laboratory conditions for making this
practical file.
I also extend my thanks to a number of
teachers, my classmates and friends who
helped me to complete this practical file
successfully.
Sneha kiran
CERTIFICATE
This is to certify that Sneha Kiran of class X C
has successfully completed the Information
Technology - 402 project on the topic Hospital
Management System under the guidance of
Prahlad Baraik during the academic year
2022-23.
Subject – Teacher Principal
Signature
INTRODUCTION
I have taken a case study for the automation of Hospital
Management. It maintains two levels of users :-
➢Administrator Level
➢User Level
My OO Base Project Work includes the following reports:
➢Maintaining Patient details
➢Providing Prescription, Precautions and Diet advice
➢Providing and maintaining all kinds of tests for a
patient
➢Billing and Report generation
It can be used in any Hospital, Clinic, Dispensary or
Pathology labs for maintaining patient details and their test
results.
This project will be a desktop application to be developed in
VB 6.0 having Ms Access as backend.
• Database Design (Ms Access)
• Form Design (VB 6.0)
• Coding (VB 6.0)
• Testing (VB 6.0)
• Reporting Tool (Data Report)
Main facilities available in this project are :-
• Maintaining records of indoor/outdoor patients
• Maintaining patients diagnosis details, advised tests
to be done
• Providing different test facilities to a doctor for
diagnosis of patients
❖ X-Ray
❖ Urine Test
❖ Stool Test
❖ Sonography Test
❖ Gastroscopy Test
❖ Colonoscopy Test
❖ Blood Test
❖ Biochemistry Test
• Maintaining patient's injection entry records
• Maintaining patient's prescription, medicine and
diet
advice details
• Providing billing details for indoor/outdoor
patients
• Maintaining backup of data as per user
requirements
(between mentioned dates)
• If user forgets his/her password then it can be
retrieved by hint question
In this project collection of data is from different pathology
labs. Results of tests, prescription, precautions and diet
advice will be automatically updated in the database.
Related test reports, patient details report, prescription and
billing reports can be generated as per user requirements.
User or Administrator can search a patient's record by
his/her name or their registration date. Patient's diet advice
can be provided in Hindi.
OBJECTIVE
1. Planned approach towards working: The working in
the organization will be well planned and organized. The
data will be stored properly in data stores. which will
help in retrieval of information as well as its storage.
2. Accuracy: The level of accuracy in the proposed system
will be higher. All operation would be done correctly and
it ensures that whatever information is coming from the
center is accurate.
3. Reliability: The reliability of the proposed system will
be high due to the above stated reasons. The reason for
the increased reliability of the system is that now there
would be proper storage of information.
4. No Redundancy: In the proposed system utmost care
would be that no information is repeated anywhere, in
storage or otherwise. This would assure economic use of
storage space and consistency in the data stored.
5. Immediate retrieval of information: The main
objective of proposed system is to provide for a quick
and efficient retrieval of information. Any type of
information would be available whenever the user requires.
6. Immediate storage of information: In manual system
there are many problems to store the largest amount of
information.
7. Easy to Operate: - The system should be easy to
operate and should be such that it can be developed
within a short period of time and fit in the limited
budget of the user.
Problems with conventional system
1) Lack of immediate retrievals: -The information is very
difficult to retrieve and to find particular information like-
E.g. To find out about the patient's history, the user has to
go through various registers. This results in inconvenience
and wastage of time.
2) Lack of immediate information storage: - The
information generated by various transactions takes time
and efforts to be stored at right place.
3) Lack of prompt updating: Various changes to information
like patient details or immunization details of child are
difficult to make as paper work is involved.
4) Error prone manual calculation: - Manual calculations
are error prone and take a lot of time this may result in
incorrect information. For example calculation of patient's
bill based on various treatments.
5) Preparation of accurate and prompt reports: - This
becomes a difficult task as information is difficult to collect
from various registers.
Alternative Solutions
1. Improved Manual System:- One of the alternative solutions
is the improvement of the manual system. Anything, which
can be done by using automated methods, can be done
manually. A more sophisticate register maintenance for
various Patient Information, Doctor diary. Immunization
Details and a good system for writing bill amount employees
and stock availed for the customers can be maintained at
central place. Adequate staff may be maintained so that
updations are made at the very moment at the same time.
Proper person for proper work should be made responsible so
that a better efficiency could be achieved. This needs a lot of
work force.
2. Online System:- This system (HMS) provides online
storage/updations and retrieval facility. This system promises
very less or no paper work and also provides help to Doctor
and operational staff. In this system everything is stored
electronically so very less amount of paper work is required
and information can be retrieved very easily without
searching here and there into registers. This system is been
discussed here.
DATA TABLES
1. Login Table :-
2. Patient Detail Table :-
3. Patient Diagnosis Table:-
4. Patient Diet Advice Table:-
5. Patient Medicine Table:-
6. Patient Injection Dates Table:-
7. Biochemistry Test Table:-
8. Blood Test Table:-
9. Colonoscopy Test Table:-
10) Patient Fee Table:-
Snapshots
1) Login Form
2) Home Page
3) Patient Entry Form
4) Prescription Entry Form
5) Patient Diagnosis History Form
6) Patient Injection Entry Form
7) Patient Receipt Entry Form
8) Patient Receipt Query Form
9) Gastroscopy Test Form
10) Biochemistry Test Form
11) Colonoscopy Test Form
12) Blood Test Form
13)Stool Test Form
14) Sonography Test Form
15) Urine Test Form
16) Test Reports Form
17) Search By Name Form
18) Search By Date Form
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, diet advice and medicines prescribed
to patient and doctor. It also provides injection details and
billing facility on the basis of patient's status whether it is
an indoor or outdoor patient. The system also provides the
facility of backup as per the requirement.
Bibliography
I. Mastering VB 6.0
II. SMS hospital
III. [Link]
Project_Hospital_management_system
IV. [Link]
Hospital_Database_Management_System_
sql_project_report_