DESIGN AND IMPLEMENTATION OF HEALTH CLINICAL DATABASE INFORMATION

ABSTRACT

This project was centered on health clinical database information system. The current process of keeping records of patients is being operated manually and due to this procedure numerous problem are been encountered. A design was taken to computerized the manual process in order to check this problem. The problems were identified after series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The new system was designed using Microsoft visual basic 6.0 programming language. This language was chosen because of its easy syntax and features for developing windows based applications.

TABLE OF CONTENTS
Cover page
Title page
 Certification
Dedication
Acknowledgement
Abstract
Table content

CHAPTER ONE
1.0 Introduction
1.1 Background of study
1.2 Statement of the problem
1.3 Objectives of the study
1.4 Scope of the study
1.5 Limitation of the study
1.6 Methodology
1.7 Definition of terms
1.8 Data dictionary


CHAPTER TWO
2.0 Literature review
2.1 Drug dispensing samples words of caution
2.2 Database management system
2.3 Expert system technology
2.4 Clinical computing and the computer based patient record
2.5 Advantages of computer-based medical records
2.6 Routes of drug administration
2.7 Evaluation of clinical method

CHAPTER THREE
3.0 System analysis
3.1 Introduction
3.2 Organogram of fedponek medical centre
3.3 Detailed analysis of the present system
3.3.1 The administrative unit
3.3.2 The Pharmaceutical unit
3.3.3 Operations and pharmaceutical unit
3.3.4 How drugs are received and dispensed
3.3.5 Nursing unit
3.3.6 The public health unit
3.3.7 The medical record unit
3.3.8 The laboratory unit
3.3.9 Procedure for admission and discharge of patient
3.4 Flowchart of medical procedure in federal polytechnic nekede medical centre
3.5 Problems observed in the present system
3.6 Expectation of the new system
3.7 Data flow diagram

CHAPTER FOUR
4.0 System design
4.1 Database structures
4.2 Input design
4.3 Output design
4.4 Program design
4.5 Top down design
4.6 Program module flowchart (symbols)
4.7 Specification of program module
4.8 Program coding

Chapter five
5.0 Program implementation and documentation
5.1 Introduction
5.2 File conversion
5.3 Site preparation
5.4 Training
5.5 Hardware and software requirement
5.6 Material requirements
5.7 System test run
5.8 System maintenance
5.9 Documentation
5.9.1 Operational principles

CHAPTER SIX
Conclusion and recommendation
6.1 Conclusion
6.2 Recommendation