Automated Drug Tracking Information System:- Ugochukwu, Joshua I.

ABSTRACT

Automated Drug Tracking Information System is a set of computer programs that obtains the supplies of drugs, distribute the drugs and monitors the inventory control of the drugs. The pharmaceutical department of University of Nigerian Teaching Hospital (UNTH), Enugu is used as a case study. I was motivated to embark on this research because the department uses manual method to operate drugs related operations, which lacks good storage system for drugs recording. The 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 an information system. The objectives are to develop a platform for real time automated drug tracking information system, to build a database structure used to store information about drug using SQLite database, design a platform that helps to order for require drugs, create a module for taking good stock of drugs, create a platform that help to track dispensary of expired drugs. This research was realized through the adoption of primary and secondary sources of data collection which includes interview, observation, questionnaire, the internet and journals. The system was developed using Java for designing and implementation of the program system to enable accurate record keeping of drug to track expired drug. This guarantees the people the right to good health care and ensures that drugs received are genuine and safe

TABLE OF CONTENTS

Title Page                                                                                                                    i

Certification                                                                                                                ii

Dedication                                                                                                                 iii

Acknowledgments                                                                                                     iv

Table of Contents                                                                                                       v

Abstract                                                                                                                      viii

CHAPTER 1             INTRODUCTION

1.1              Introduction                                                                                                    1

1.2       Statement of the Problem                                                                               3

1.3       Aim Objectives of the Study                                                                          3

1.4       Significance of the Study                                                                               4

1.5       Scope of the Study                                                                                         4

1.6       Background of the Case Study                                                                      5

CHAPTER 2             LITERATURE REVIEW

2.1       Developmental Milestones and Achievements of University of

Nigeria Teaching Hospital Enugu                                                                   6

2.2       Pre-Independence Era                                                                                    7

2.3       Computerization ICT                                                                                      10

2.2       Pharmacy                                                                                                        11

2.2.1    Disciplines                                                                                                       12

2.2.3    Pharmacy technicians                                                                                      14

2.2.4    Education Requirements                                                                                 14

2.2.5    Types of Pharmacy                                                                                         15

2.3       History of Pharmacy                                                                                       22

2.4       SMS phar­ma­ceut­ical Verification for Counterfeit Drugs                               25

2.5       Challenges of the Proposed System                                                               26

CHAPTER 3             RESEARCH METHODOLOGY AND SYSTEM ANALYSIS

3.1       Research Methodology                                                                                   27

3.1.1    Choice of the research methodology                                                              27

3.1.1.1 The advantages of RAD include                                                                    29

3.1.1.2 The disadvantages of RAD include                                                               30

3.2       Analysis of the Existing System                                                                     31

3.3       System Investigation                                                                                      32

3.4       Analysis of the proposed system                                                                    32

3.5       Method of Data Collection                                                                             32

3.5.1    Sources of data Used                                                                                      32

3.5       Data Flow Diagram                                                                                        35

CHAPTER 4             SYSTEM DESIGN AND IMPLEMENTATION

4.1       Overview of the System Design                                                                     36

4.2       Input Form Design                                                                                          36

4.4        Process Design                                                                                                38

4.4       Program Flowchart                                                                                         39

4.5       Output Form Design                                                                                       40

4.6       Databases Design                                                                                            40

4.7       Program Design                                                                                              41

4.8       System Implementation                                                                                  41

4.9       Database table implementation                                                                       44

4.10     Project Costing                                                                                               44

CHAPTER 5             SUMMARY, CONCLUSION AND RECOMMENDATION

5.1       Summary                                                                                                         46

5.3       Conclusion                                                                                                      46

5.3       Recommendations                                                                                          47

REFERENCES                                                                                                        48

APPENDIX A

Program Source Code                                                                                                 50

APPENDIX B

Program Output                                                                                                          53