ABSTRACT
Clinical database typical contain a significant amount of
temporary information. Information is often crucial in medical decision support
system. This project involves a careful study of an existing manual system, the
designing and implementing a clinical patient database system, using Federal Teaching Hospital Abakaliki as the case
study. The major areas considered are the General Administrative Unit, the
Pharmaceutical unit the Nursing Unit, the Laboratory Unit the Public Health Unit the wards and the medical record
unit. With the comprehensive information obtained from the Teaching Hospital, medical centre and from other
different medical sources, I developed a clinical patient database framework for
managing the operations of the clinic. This
software will help a quick access to patient medical records such as
patient name, patient diagnosis, prescriptions, drugs dispensed allocation of
roads patient’s treatment etc. the software is designed and implemented using
Visual Basic 6.0. This scalable system
can also be extended to manage larger clinics and relevant computerized health
centre.
TABLE
OF CONTENTS
Title Page i
Certification Page ii
Dedication iii
Acknowledgement iv
Abstract v
Table of Contents vi
CHAPTER ONE
1.1 Introduction 1
1.2 Brief History of Imo
State University
Medical Centre 2
1.2.1 Organogram of Imo State University Medical Centre 3
1.3 Statement of the Problem 4
1.4 Objectives of the Study 4
1.5 Scope and Delimitation of the Study 5
1.6 General Methodology 5
CHAPTER TWO
2.0 Literature Review 7
2.1 Drug Dispensing Samples Words of Caution 11
2.2 Database Management System 13
2.3 Expert System Technology 14
CHAPTER THREE
3.0 System Investigation, Analysis and Design of I/O forms 16
3.1 Definition of Terms 16
3.2 Data Dictionary 17
3.3 Detailed Analysis of the Present System 17
3.3.1 The Administrative Unit 17
3.3.2 The Pharmaceutical Unit 17
3.3.3 The Objectives of the Pharmaceutical Unit 18
3.3.4 Operation of the Pharmaceutical Unit 18
3.3.5 How Drugs are Received and Dispensed 19
3.3.6 Nursing Unit 19
3.3.7 The Public Health Unit 19
3.3.8 The Medical Records Unit 20
3.3.9 The Laboratory Unit 20
3.4 Problems Observed in the Present System 20
3.4.1 Expectation From the New System 21
3.5 Procedure for Admission and Discharge of Patient 21
3.6 Data Flow Diagram 22
3.7 System Design 25
3.8 Data Base Structures 25
3.9 Input Design 26
3.10 Output Design 29
3.11 Program Design 29
3.12 Top Down Design 29
CHAPTER FOUR
4.0 Programming, Testing and Implementation 30
4.0.1 File Conversion 30
4.0.2 Site Preparation 31
4.0.3 Training 31
4.0.4 Hardware and Software Requirement 31
4.0.5 Material Requirement 32
4.1 Program Module Flowchart 32
4.2 Specification of Program Module 39
4.3 Program Coding and Testing 39
4.4 System Maintenance 40
4.5 Documentation 41
4.6 Operational Principles 41
CHAPTER FIVE
5.0 Summary, Conclusion and Recommendation 42
5.1 Problems Encountered 42
5.2 Summary 42
5.3 Conclusion 43
5.4 Recommendation 44
References 45
Appendix
No comments:
Post a Comment