ABSTRACT
The study was carried out to verify all the manual
processes involved in medical patient history information system and to seek
for a way of automating the system for effective operations.
Since,
there are continuous moves towards technological advances that enhance
productivity of labour and free human beings of task done more economically by
machines. Computer and its applications
have become indispensable vital tools in economic, industrial and social
development of the advanced countries of the world. Nigeria as a developing
country cannot afford to lag too far behind in this kind of revolution. Therefore there is every need to know in
every discipline the areas which attracts computerization and why they need it.
In
this project, the software engineering principles were applied in the analysis,
design, coding testing of software serious attention was also given to the
design of the user interface.
In
the development of the software, visual basic programming language was used due
to its support for all the features desired.
A brief user’s guide is also provided.
The end result is a software that is very effective and efficient in
meeting its objectives and at the same time user friendly.
TABLE OF CONTENT
Title
page ii
Certification
iii
Dedication iv
Acknowledgement v
Abstract
vi
Table
of contents viii
CHAPTER ONE
Introduction 1
- Theoretical
background of the study 1
- Statement of the
problem 4
- Purpose of the
study 5
- Aims and objectives of
the study 5
- Significance of
the study 6
- Limitations 6
- Definitions of terms 7
CHAPTER TWO
Literature
Review 8
- General review
of database storage and retrieval system 8
- Database retrieval
techniques 17
CHAPTER THREE
Analysis
of the existing system 20
- Fact finding
method 21
- Objectives of
the existing system 22
- Input, process
and output analysis 22
- Problems of the
exiting system 24
- Justification for New
system 26
CHAPTER FOUR
Design
of a New System 27
- Input
specification and design 27
CHAPTER FIVE
Implementation 33
CHAPTER SIX
Documentation 39
CHAPTER SEVEN
Recommendation 41
Conclusion 42
References 43
CHAPTER ONE
INTRODUCTION
- THEORETICAL
BACKGROUND
Information system is a collection of logically related files,
organized in a manner to satisfy the needs of an organization. A database is a store of data structured so
that access and update can be made by different people in different ways
without needs to change its design or content for this to happen, it is
essential that all data items are logically related.
Information system is always necessary
to store date items once, because of it, input cost are lower. Duplicate letters are largely dominated
thereby saving space and ensuring data consistency. Data is defined as an unprocessed fact. They are raw facts that are unprocessed. Data does not have meaning. Information is processed data through the
computer, which process different type of information. Information in the computer is stored in
codes. File is the collection of related filed, field is the collection of data
items.
Information system is important,
because important information requirement and non-specialist need easy ways of
accessing this information. Large amount
of data with many types of records occurring many times in database management
system. Also in database information
system, complex data structures including many relationships between data
items. Many organizations will have many
use requirements in data base management system. Organizations will also have many frequent
demand for changes to be made which only unflexible database management system
can cope with.
Data is viewed as a source to be
shared by as many process as possible.
As a result, data must be organized in a way that is flexible and
adaptable to un anticipation requirements.
The data which they stored in anticipation of requests, and the requests
themselves. Data may be stored as references to documents, microforms or
computer coded text, graphics etc. the
service may be offered on a local basis or through a telecommunication network. Database system may be operated by
organizations for their own benefit or offered to the public on a subscription
basic. The output from database services
is either a document or computer data presented, say, on a video display unit
or a voice output.
The main purpose of database is to
satisfy the user information needs. The
way in which these needs are expressed largely determined the principles of
operation of a particular database system.
Perhaps the most straight forward
request for database is when the user supplies a complete reference for a
document. The job of the service then is to locate a copy of the document and
deliver it to the user. This is usually
referred to as document retrieved service.
It may be aided by computers in compelling the index to the documents in
store, and in physically locating a required document as in a computerized
warehouse.
More after then not, however, database
need are expressed in terms of a request for data such as, how many patient are
being admitted monthly in a hospital? Or what kind of sickness of a patient? To
answer such questions reference must be made to records stored either in
printed form or as computer coded data.
The first of there is often refered to as information retrieval, the
later as database search, when the index to the printed record is computerized.
The database distribution system, with
the added facility of storage at computer coded text, offer one approach to
reducing, the physical size of records, and to mechanizing their search
and retrieval the records unfortunately,
first have to be converted into computer compatible form, and can be consulted
only after reconversion via some printing or display device.
- STATEMENT
OF THE PROBLEM
There has been this
problem of too much work for the nurses in the hospital. Owing to the growing population of patient in
the hospital, the nurses are faced with heaps of file. At times, sorting out a particular patient
file takes most a month.
Also there have been cases of missing files. Due to lack of security in the office and the poor filling system in use, the patient files at times get lost and it then becomes difficult to access the concerned patient information.
This bitter complaints and the delay in the receiving of information for the management had been the major concern and therefore has intensified the need to design a software which will go a long way in tackling these problems and at the same time helps to quicken database processing.
DESIGN AND IMPLEMENTATION OF COMPUTERIZED MEDICAL PATIENT HISTORY MANAGEMENT INFORMATION SYSTEM A CASE STUDY OF UNIVERSITY TEACHING HOSPITAL, UNTH, ENUGU.
