ABSTRACT
This project is aim at developing an Automated
Hospital Management System using a function-oriented design. Every cooperate
organization, institution or government agency requires data and good quality
information to function effectively. It is not an over statement to say that
many organizations, institutions or government agencies have become critically
dependent on the use of database system for their successes especially in the
hospital. Data collected from various sources for example telephone, fax,
verbal messages, mails etc. are used in decision making, planning and control
of operations in management of clients, personnel and recourses. The poor
efficiency of the present manual management system in hospitals today results
from the inordinate length of time it takes to search for and locate patient
folders and the ineffective filling system adopted. In this project the SQL
Server database is the database server where the data is sent to and retrieved
from while Active Server Pages (.net programming language) is the client which
provides the user interface design and the forms used by the doctors, staff and
nurses during administration in the office, laboratory, wards, pharmacy, X-ray
etc.
TABLE
OF CONTENT
|
|||||
TITLE PAGE
|
I
|
||||
APPROVAL PAGE
|
II
|
||||
DEDICATION
|
III
|
||||
ACKNOWLEDGEMENT
|
IV
|
||||
ABSTRACT
|
V
|
||||
LIST OF FIGURES
|
VI
|
||||
LIST OF TABLES
|
VII
|
||||
TABLE OF CONTENTS
|
VIII
|
||||
CHAPTER
ONE: INTRODUCTION
|
1
|
||||
1.0
|
Background Information
|
1
|
|||
1.1
|
Classification of Hospital
|
1
|
|||
1.1.1 Community Hospitals
|
1
|
||||
1.1.2 Teaching Hospital
|
2
|
||||
1.1.3
|
Public Hospitals
|
3
|
|||
1.1.4
|
General Hospital
|
3
|
|||
1.1.5
|
District Hospital
|
3
|
|||
1.1.6
|
Specialized Hospital
|
3
|
|||
1.1.7
|
Clinics
|
4
|
|||
1.2
|
Manual Workflow Of The Hospital
|
4
|
|||
1.3
|
Brief Description Of Hospital
Activities
|
5
|
|||
1.4
|
Problems Of The Manual System
|
6
|
|||
1.5
|
Need For Automated System
|
7
|
|||
1.6
|
Project Objectives
|
8
|
|||
1.7
|
The Project Scope
|
8
|
|||
1.8
|
Project Organisation
|
9
|
|||
CHAPTER
TWO: LITREATURE REVIEW
|
11
|
||||
2.0
|
Literature Review
|
11
|
|||
2.1
|
Evaluation of Healthcare
|
12
|
|||
2.2
|
System Quality
|
12
|
|||
2.3
|
Reliability and Validity of Quality
Measures
|
15
|
|||
2.4
|
Cost and Benefit
|
15
|
|||
2.5
|
Service Performance
|
18
|
|||
2.6
|
Time Efficiency
|
19
|
|||
2.7
|
Usability
|
20
|
|||
2.8
|
Legal Aspect
|
23
|
|||
2.9
|
Legal Interoperability
|
23
|
|||
2.10
|
Importance
|
24
|
|||
Database
|
25
|
||||
2.12
|
The Need for A Database System
|
25
|
|||
2.13
|
Types of Database System
|
25
|
|||
2.14
|
Non-Integrated Database System
|
26
|
|||
2.14.1 Increased Cost
|
26
|
||||
2.14.2 Stored Data Inconsistency
|
27
|
||||
2.14.3 Redundancy of Data
|
27
|
||||
2.14.4 Lack of Data Integrity
|
27
|
||||
2.15
|
Application of Database
|
27
|
|||
2.16
|
Basic Concept in Database Management
|
||||
System
|
28
|
||||
2.16.1 Database Administrator (Dba)
|
28
|
||||
2.16.2 Data Model
|
29
|
||||
2.16.3 Record
|
33
|
||||
2.16.4 Store Field
|
34
|
||||
2.16.5 Data Items
|
34
|
||||
2.16.6 Data Collection
|
34
|
||||
2.17
|
Components of Database Management
System
|
35
|
|||
2.17.1 Database Management System Engine
|
35
|
||||
2.17.2 Database Definition Subsystem
|
35
|
||||
2.17.3 Data Manipulation Subsystem
|
35
|
||||
2.17.4 Application Generation
Subsystem
|
35
|
||||
2.17.5 Data Administration Subsystem
|
35
|
||||
2.18
|
Oracle Database
|
36
|
|||
2.18.1 Component of Oracle Database
|
37
|
||||
2.19
|
Hospital Management
|
38
|
|||
CHAPTER
THREE: SYSTEM ANALYSIS AND
|
|||||
SPECIFICATION
|
40
|
||||
3.0
|
Requirement Analysis and
Specification
|
40
|
|||
3.1
|
Requirement Analysis
|
41
|
|||
3.2
|
Data Collection
|
41
|
|||
3.3
|
Data Storage
|
42
|
|||
3.4
|
Data Communication And Manipulation
|
42
|
|||
3.5
|
Data Security
|
43
|
|||
3.6
|
System Cost
|
43
|
|||
3.7
|
Requirement Specifications
|
44
|
|||
3.8
|
Unit Requirement Definition
|
45
|
|||
3.9
|
Function Specification
|
45
|
|||
3.10
|
Hospital Operation Flow System
|
46
|
|||
3.11
|
The Modules Of Automated Hospital
|
||||
Management System
|
48
|
||||
3.11.1 Patient Registration/Carding
System
|
48
|
||||
3.11.2 Patient History And Record
System
|
50
|
||||
Software Testing/Verification
|
89
|
||
5.8.1
|
Debugging
|
90
|
|
5.8.2
|
Operational Flow Testing
|
90
|
|
5.8.3
|
Data Integrity And Format Testing
|
90
|
|
5.8.4
|
Load Testing
|
90
|
|
5.9
|
Project Cost
|
90
|
|
CHAPTER
SIX: EVALUATION
|
91
|
||
6.0
|
Evaluation
|
91
|
|
6.1
|
Achievement
|
92
|
|
6.2
|
Cost Analysis Of The Project
|
93
|
|
6.3
|
Recommendation
|
96
|
|
6.4
|
Conclusion
|
97
|
|
REFERENCES
|
98
|
||
APPENDIX
|
103
|
CHAPTER
ONE
1.0
BACKGROUND INFORMATION
A hospital is an institution for
health care that provides patient treatment by specialized staff and equipment.
Usually, hospitals are funded by the public sector, by health organizations
(for profit or nonprofit), health insurance companies or charities, including
funds by direct charitable donations. Historically, however, hospitals were
often founded and funded by religious orders or charitable individuals and
leaders. Modern-day hospitals are largely staffed by professional physicians,
surgeons, and nurses.
1.1
CLASSIFICATION OF HOSPITAL.
Hospitals are distinguished by their
ownership, scope of services, and whether they are teaching hospitals with
academic affiliations. Hospitals may be operated as proprietary (for-profit)
businesses, owned either by corporations or individuals such as the physicians
or they may be voluntary-owned by non-profit corporations, religious
organizations, or operated by federal, state, or city governments. Voluntary
and non-profit hospitals are usually governed by a board of trustees, selected
from among community business and civic leaders, who serve without pay to
oversee hospital operations.
1.1.1
COMMUNITY HOSPITALS
Most community hospitals offer
emergency services as well as a range of inpatient and outpatient medical and
surgical services. Community hospitals, where most people receive care, are
typically small, with fifty to five hundred beds. These hospitals normally
provide quality care for routine medical and surgical problems.
Some community hospitals are nonprofit
corporations, supported by local funding. These include hospitals supported by
religious, cooperative, or osteopathic organizations. In the 1990s, increasing
numbers of not-for-profit community hospitals have converted
their ownership status, becoming proprietary hospitals that are owned and
operated on a for-profit basis by corporations. These hospitals have joined
investor-owned corporations because they need additional financial resources to
maintain their existence in an increasingly competitive industry.
Investor-owned corporations acquire not for-profit hospitals to build market
share, expand their provider networks, and penetrate new health care markets.
1.1.2
TEACHING HOSPITALS
Teaching hospitals are those community
and tertiary hospitals affiliated with medical schools, nursing schools, or
allied-health professions training programs. Teaching hospitals are the primary
sites for training new physicians where interns and residents work under the
supervision of experienced physicians. Non teaching hospitals also may maintain
affiliations with medical schools and some also serve as sites for nursing and
allied-health professions students as well as physicians-in-training.
Most teaching hospitals, which provide
clinical training for medical students and other health care professionals, are
affiliated with a medical school and may have several hundred beds. Many of the
physicians on staff at the hospital also hold teaching positions at the
university affiliated with the hospital, in addition to teaching
physicians-in-training at the bedsides of the patients. Patients in teaching
hospitals understand that they may be examined by medical students and
residents in addition to their primary "attending" physicians.
One advantage of obtaining care at a
university-affiliated teaching hospital is the opportunity to receive treatment
from highly qualified physicians with access to the most advanced technology
and equipment. A disadvantage is the inconvenience and invasion of privacy that
may result from multiple examinations performed by residents and students. When
compared with smaller community hospitals, some teaching hospitals have
reputations for being very impersonal; however, patients with complex, unusual,
or difficult diagnoses usually benefit from the presence of
acknowledged medical experts and more comprehensive resources available at
these facilities. A teaching hospital combines assistance to patients with
teaching to medical students and nurses and often is linked to a medical
school, nursing school or university.
1.1.3
PUBLIC HOSPITALS
Public hospitals are owned and
operated by federal, state, or city governments. Many have a continuing
tradition of caring for the poor. They are usually located in the inner cities
and are often in precarious financial situations because many of their patients
are unable to pay for services. The federal government matches the states' contribution
to provide a certain minimal level of available coverage, and the states may
offer additional services at their own expense.
1.1.4
GENERAL HOSPITAL
This is the best type of hospital, it
is set up to deal with many kinds of diseases and injuries, and normally has an
emergency department to deal with immediate and urgent threats to health.
1.1.5
DISTRICT HOSPITAL
This is the major health care facility
in its region, with large numbers of beds for intensive care and long-term
care; and specialized facilities for surgery, plastic surgery, childbirth, and
bioassay laboratories.
1.1.6
SPECIALIZED HOSPITAL
This is a special type of hospital
meant for a particular case like trauma centers, rehabilitation hospitals,
children's hospitals, seniors' (geriatric) hospitals, and hospitals for dealing
with specific medical needs such as psychiatric problems, certain disease
categories such as cardiac, intensive care unit, neurology, cancer center, and
obstetrics and gynecology, oncology, or orthopedic problems.
A medical facility smaller than a
hospital is generally called a clinic, and often is run by a government agency
for health services or a private partnership of physicians (in nations where
private practice is allowed). Clinics generally provide only outpatient
services.
1.4
PROBLEMS OF THE MANUAL SYSTEM
Lack
of immediate retrieval:-
The information is very difficult to retrieve and to find particular
information e.g. - To find out about the patient’s history, the user has to go
through various registers. This results in inconvenience and waste of time.
Lack
of immediate information storage:
- The information generated by various transactions takes time and efforts to
store them.
Error
prone manual calculation:
- Manual calculations are error prone and takes a lot of time, this may result
in incorrect information. For example, calculation of patient’s bill based on
various treatments.
Preparation
of accurate and prompt reports:
- This becomes a difficult task as business intelligence is difficult, this is
due to lack of information collation (ability to put information together and
analyze them).
TOPIC: AUTOMATED HOSPITAL MANAGEMENT SYSTEM
Chapters: 1 - 5
Delivery: Email
Delivery: Email
Number of Pages: 100
Price: 3000 NGN
In Stock

No comments:
Post a Comment
Add Comment