Loading ....


DESIGN AND IMPLEMENT A COMPUTERIZED DRUG INFORMATION MANAGEM

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

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

6

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

7

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

8

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.1The 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 Top-down 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

9

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 people’s right to good health care and ensures that drugs received are genuine and safe.


NOTE: To have an access to Download this material please contact Us On
+234-903-685-7618, Any Time
Or Or Locate us at pam industrial estate Block 4 Makurdi, Benue State

Click here to make a payment Online or get Payment details