DESIGN AND IMPLEMENTATION OF A COMPUTERIZED HOSPITAL PATIENT MANAGEMENT SYSTEM

ABSTRACT

The study was carried out to design and implement a computerized hospital patient management system, eliminate redundancy in term of data storage,          reduce the time wasted in retrieving data especially in finding a past health records, increase efficiency and interactivity in any area of specialization in the hospital.

A function oriented model was adopted for this study. The Oracle 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 e.t.c.

TABLE OF CONTENTS

TITLE                                                                                               PAGE

TITLE PAGE

CERTIFICATION

DEDICATION

ACKNOWLEDGEMENT

ABSTRACT

TABLE OF CONTENTS

CHAPTER ONE: INTRODUCTION

1.1     Background to the Study

1.2     Statement of the Problems

1.3     Objectives of the Study

1.4     Significance of the Study

1.5     Definition of Terms

CHAPTER TWO: LITERATURE REVIEW

2.1     Introduction

2.2     Evaluation of Health Care

2.3     Classification of Hospital

2.3.1 Community Hospitals

2.3.2 Teaching Hospitals

2.3.3 Public Hospitals

2.3.4 General Hospital

2.3.5 District Hospital

2.3.6 Specialized Hospital

2.3.7  Clinics

2.4     Features of A Good Hospital Management System

2.5     Database

2.5.1  The Need for a Database System

2.5.2  Types of Database System

2.6     Application of Database

2.7     Basic Concept in Database Management System

2.7.1  Database Admisntrator (DBA)

2.7.2 Data Model

2.7.3 Benefits of a Computerized Hospital Management System

CHAPTER THREE: SYSTEM ANALYSIS AND SPECIFICATION

3.1     Requirement Analysis

3.2     Data Collection

3.3     Data Storage

3.4     Data Communication and Manipulation

3.5     Data Security

3.6     System Cost

3.7.     Unit Requirement Definition

3.8     Function Specification

3.9     Hospital Operation Flow System

3.10   The Modules of Automated Hospital Management System

3.10.1         Patient Registration / Carding System

3.10.2 Patient History and Record System

3.10.3 Nurses Work Bench

3.10.4 Doctors Work Bench

3.10.5 Appointment / Waiting List Module

3.10.6 Doctor’s Diagnostic System

3.10.7 Laboratory System / X – Ray

3.10.8 Pharmacy

3.10.9 Administrative System

3.11   Accounting / Billing System

3.11.1 Referral System

CHAPTER FOUR

4.0 Software Design

4.1 Structured Design

4.2. System Processing Transformation

4.3. Input Transformation

4.4. Output Transformation

4.5. Entity Relationship Model (Erm) of the Design

4.6. Design Database Schema

4.7 Program Design

4.8 Report and Analysis

4.9 Diagnosis (Doctor Workbench)

4.10 X - Ray

4.11 Billing / Accounting System

CHAPTER FIVE

5.0 Implementation and Testing

5.1 User Interface

5.2 Types of User Interface

5.2.1 Graphic User Interface

5.2.2 Web-Base User Interfaces

5.2.3 Command Line Interface

5.2.4 Touch User Interface

5.2.5 Natural Language Interface

5.3 Security

5.3.1 Client Software Security

5.3.2 Database Server (Oracle) Security

5.4 Software Testing/Verification

5.4.1 Debugging

5.4 .2 Operational Flow Testing

5.4.3 Data Integrity and Format Testing

5.4.4 Load Testing

References

Appendix