DESIGN AND IMPLEMENTATION OF A COMPUTERIZED DRUG INFORMATION MANAGEMENT

Description

TABLE OF CONTENTS

Title page i

Certification ii

Dedication iii

Acknowledgement iv

Table of content v

List of figure ix

List of table ix

Abstract x

CHAPTER ONE INTRODUCTION 1.1

Background of study 1 1.2

Statement of problem 3 1.3

Objectives of the study 4 1.4

Significance of the study 4 1.5

Scope of the study 5

1.6 Assumption 5

1.7 Limitations of the study 6 1.8

Project report organization 6 1.9

Definition of Terms 7

CHAPTER TWO LITERATURE REVIEW 2.1

Computerization in drug management system 9

2.2 General overview of drug management information system 10

2.3 Drug Procurement 11

2.4 Drug Distribution 12

2.5 Visual Basic 6.0 13

2.6 Softrex Formular 14

2.7 Management Information System 15

2.8 Benefits of Management Information System 15

2.9 Component of a Database Management System 16

CHAPTER THREE SYSTEM ANALYSIS AND DESIGN

3.1 Methodology 18

3.1.1 Structured system Analysis and Design Methodology SSADM 18

3.1.2 Expert System 19

3.1.3 Prototyping 20

3.2 Data collection 21

3.2.1 The Primary Collection 21

3.2.2 The Secondary Collection 22

3.3 Analysis of Existing System and Design 22

3.3.1 The Pharmacy Department 23

3.3.2 UNTH Inpatient Drug Management 23

3.3.3 Drug Procurement System in UNTH 24

3.3.4 The Patient Medication Sheet and Treatment 24

3.3.5 Present System Approach to Drug Management 26

3.4 Limitations of the Existing System 28

3.5 System Design 29

3.5.1 Expectations of the New System 29

3.5.2 Design of the New System 30

3.5.3 File Specification 31

3.5.3.1 File Operation 31

3.5.3.2 Edit Menu 31

3.5.3.3 Administrator 31

3.5.4 The Registration Form 32

3.5.5 Drug Statistics and Stock Balancing 32

3.5.6 Program Assets 32

3.6 Database File 33

3.7 System Flowchart 38

3.8 Top down diagram 43

CHAPTER FOUR IMPLEMENTATION, TESTING, AND PACKAGEING

4.1 Choice of Development Tools 45

4.2 System Requirements 46

4.2.1 Software Requirements 46

4.2.2 Hardware Requirements 46

4.3 Implementation 47

4.4 Testing 51

CHAPTER FIVE SUMMARY, RECOMMENDATION AND CONCLUSION

5.1 Summary 55

5.2 Limitations 55

5.3 Recommendation 56

5.4 Beme Bill of Engineering Measurement and Evaluation 56

5.5 Conclusion 57

BIBLOGRAPHY 58

APPENDIX A 61

APPENDIX B 74

LIST OF FIGURES Figure 3.1

The Pharmaceutical Organization Flow Chart 25

Figure 3.2

Data Flow Diagram 38

Figure 3.3 Logic scheme for the new system 39 Figure 3.4 Flowchart program set up/ company set up 40 Figure 3.5 Flowchart for login module 41 Figure 3.6 Flowchart for drug procurement 42 Figure 3.7 Topdown diagrams 43 LIST OF TABLES Table 3.1 Login menus 33 Table 3.2 Drug inventory table 33 Table 3.3 Drug Procurement 34 Table 3.4 Drug Distributions 35

Table 3.5 New patients 36 Table 3.6 Patient medications 36 ABSTRACT Drug procurement and distribution tracking system is a set of computer programs that obtains the supplies of drugs, distribute the drugs and monitors the inventory control of the drugs. Using the pharmaceutical department of Port Harcourt University teaching hospital as a case study, the department using manual method to operate lacks good storage of information system for drugs. Recording system tends to be complex and the method of tracking expired drug is poor. The good approach to this problem is to involve the use of computer by designing the form, using Access in developing the database and Visual basic as the programming language, to enable keeping accurate record of drug and prevent sales of expired drug. This guarantees the peoples right to good health care and ensures that drugs received are genuine and safe.