DESIGN AND IMPLEMENTATION OF DATA MINING FOR MEDICAL RECORD SYSTEM. (A CASE STUDY OF OWERRI GENERAL HOSPITAL)

TABLE OF CONTENTS

Title Page

Approval Page………………………………………………………………..i 

Certification Page…………………………………………………………… ii 

Dedication……………………………………………………………………iii

Acknowledgement…………………………………………………………...v 

Table of Contents…………………………………………………………… vi

Abstract……………………………………………………………………... x

CHAPTER ONE

INTRODUCTION

1.1 Background of Study……………………………………………. 1

1.2 Statement of the Problem……………………………………….. 2

1.3 Objectives of Study……………………………………………... 3

1.4 Significance of Study…………………………………………… 4

1.5 Scope of Study…………………………………………………...4

1.6 Limitations of Study………………………………………….. …4

1.7 Definition of related terms…………………………………….… 5

CHAPTER TWO

REVIEW OF RELATED LITERATURE

2.1 Introduction……………………………………….. ………..7

2.2 Review of related literature………………………………….11

CHAPTER THREE

SYSTEM ANALYSIS AND METHODOLOGY

3.1 System  analysis…………………………………..…......16

3.2 Method of data collection…………………..………........17 

3.2.1 Interviewing key officer………………………………….17

3.2.2 Observation method………………………………………18

3.2.3 Examination of document…………………………………18

3.3 Analysis of the existing system……………..……………..18

3.3.1 Organization profile chart…………………………….........18

3.3.2 Advantages of the existing system…………..….………….20

3.3.3 Disadvantage of the existing system…………….………….21

3.4 Analysis of the proposed system………………….…………21

3.4.1  Justification of the proposed system…………………………22

3.5 Methodology……………………………………………………23

3.5.1  Recommended appropriate mode…………………………….24

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

4.1 Overview of design……………………………………………25

4.2 Main menu………………………………………………….....26

4.3 Program modules specification………………………………27

4.3.1 Database design and specification……………………………27

4.3.2 Input/output specification……………………………………28

4.3.3 Input form……………………………………………………29

4.3.4 Output form…………………………………………………..31

4.3.4.1 Medical record system………………………………..32

4.4 Flowchart of the proposed solution………………………….34

4.5 Choice and justification of programming language…………..35

4.6 System requirement ………………………………………….37

4.7 Implementation plan………………………………………..37 

4.7.1 Testing………………………………………………………...38

4.7.2 Conversion…………………………………………………….39

4.7.3 Training……………………………………………………….40

4.8 Maintenance details………………………………………….40

CHAPTER FIVE

SUMMARY, RECOMMENDATIONS, CONCLUSION

5.1 Summary………………………………………………….41

5.2 Review of achievements…………………………………..42

5.3 Areas of application………………………………………..42

5.4 Suggestion for further studies………………………………42

5.5 Recommendation……………………………………………43

5.6 Conclusion…………………………………………………..43

REFERENCES…………………………………………………...45

APPENDIX A (Program codes)

APPENDIX B (Sample, output forms)

ABSTRACT

Data mining is the extraction of hidden predictive information from large database which helps in predicting future trend and behavior thereby helping management make knowledge driven decisions. The data mining tool designed is to aid in quick access and retrieval of patients information to avoid time wasted in retrieving of such data from hospitals data warehouse. The data mining tool was also designed to discover hidden pattern that helps in decision making by management. Structured System Analysis and Design Methodology were used in the analysis of the existing system which also provided a guide for the design of the proposed system.

PHP programming language and my SQL was used in the creation of a data warehouse for patient‟s information and data mining tool for the retrieval of such information when needed.