Page Length: 68

Size: 608 KB

Format: PDF & Word

5,000.00

TABLE OF CONTENTS

 

 

Title page–           –        –        –

Certification-        –        –        –

Dedication- –        –        –        –

Acknowledgement-        –        –

Table of content–          –        –

List of figure-       –        –        –

List of table-         –        –        –

Abstract-    –         –        –        –

 

 

CHAPTER ONE

INTRODUCTION

1.1 Background of study-        –

1.2 Statement of problem–

1.3 Objectives of the study-
1.4 Significance of the study-
1.5 Scope of the study-            –

1.6 Assumption-             –        –

 

–         –        –        –        –        –        – i

–         –        –        –        –        –        – ii

–         –        –        –        –        –        – iii

–         –        –        –        –        –        – iv

–         –        –        –        –        –        – v

–         –        –        –        –        –        – ix

–         –        –        –        –        –        – ix

–         –        –        –        –        –        – x

 

 

 

 

 

–         –        –        –        –        –        – 1

–         –        –        –        –        –        – 3

–         –        –        –        –        –        – 4

–         –        –        –        –        –        – 4

–         –        –        –        –        –        – 5

–         –        –        –        –        –        – 5

4

 

 

 

 

 

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

 

5

 

 

 

 

 

 

3.1.2 Expert System–              –        –        –        –        –

3.1.3 Prototyping-          –        –        –        –        –        –

3.2 Data collection-        –        –        –        –        –        –

3.2.1 The Primary Collection-           –        –        –        –

3.2.2 The Secondary Collection-  –              –        –        –

3.3 Analysis of Existing System and Design-                  –

3.3.1 The Pharmacy Department- –              –        –        –

3.3.2 UNTH Inpatient Drug Management-            –        –

3.3.3 Drug Procurement System in UNTH–                   –

3.3.4 The Patient Medication Sheet and Treatment-
3.3.5 Present System Approach to Drug Management-
3.4 Limitations of the Existing System-                 –        –

3.5 System Design-        –        –        –        –        –        –

3.5.1 Expectations of the New System-                 –        –

3.5.2 Design of the New System-                –        –        –

3.5.3 File Specification-           –        –        –        –        –

3.5.3.1 File Operation-             –        –        –        –        –

3.5.3.2 Edit Menu-         –        –        –        –        –        –

3.5.3.3 Administrator-              –        –        –        –        –

3.5.4 The Registration Form-             –        –        –        –

 

6

 

 

 

–         –        – 19

–         –        – 20

–         –        – 21

–         –        – 21

–         –        – 22

–         –        – 22

–         –        – 23

–         –        – 23

–         –        – 24

–         –        – 24

–         –        – 26

–         –        – 28

–         –        – 29

–         –        – 29

–         –         30

–         –        – 31

–         –        – 31

–         –        – 31

–         –        – 31

–         –        – 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

 

7

 

 

 

 

 

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

 

8

 

 

 

 

 

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

9

 

 

 

 

 

CHAPTER ONE

 

INTRODUCTION

 

1.1 BACKGROUND OF STUDY

Computerization  is defined  as the control of processes by computers  and  its peripherals. Today it would be difficult to think of any process, business or action that could not have profited from the numerous benefits of the computer system. Controlling process or devices    with computer started long ago since the invention of computer. In the 20th century inventors tried to make processes easier with the use of computers. Secondly computerization has been greatly applied or used in controlling process that requires frequent action such as drug procurement, drug management,  drug  tracking  and  drug  distributions  in  hospital  management information system in pharmacy departments of hospitals.

This project which is drug procurement and distribution tracking system provides a
computer based information management system in a Pharmacy Department of the
University of Nigerian Teaching Hospital  (UNTH) Enugu by designing a cost
effective, user friendly application, incorporating key attributes of data integrity
and system security suitable for use in the pharmacy department of the hospital
using Microsoft Access software in developing the database and visual basic as the

 

 

10

 

 

 

programming language. The overall aim of this project is to optimize time and material in the processing of data needed for effective operation of large pharmacy department of a hospital. By this approach, data integrity, data redundancy, and consistency will be ensured.

Drugs are the chemical substances that are administered to patients for curative purposes and prophylaxis. It can also be known as a medicine, because it is the essential part of peoples care.

The ability of the computer to store and retrieve information at a very fast and
efficient  rate  makes  its  application  useful  in  management  operations.  Drug
management involves drug procurement, drug distribution, drug tracking and its
information management. Drug distribution is concerned with distribution of drugs
within  the  different  medical  units  or  departments  in  a  hospital,  while  drug
procurement  is  concerned  with  the  purchasing  activities  of  the  drugs  by  the
pharmacy department of the hospital. In the same vein, drug tracking is concern
with the continuous monitoring of the actual quantity of drugs held in the hospital
pharmacy or any other drug warehouse /store. It also controls the stock level.

Pharmaceutical unit in a hospital is concerned with drug management activities.
They carry out the responsibility of making appropriate selection and drugs used

by formulating an annual, monthly, weekly or daily list of drugs requirement and

11

 

 

 

management reports. However, in some hospitals today, some pharmacists still use the manual system of operation which can lead to inappropriate drug management errors due to problems of handling voluminous file within a short period of time. This could make data to be easily inaccessible and also delivery of drugs can lead to misplacement of patients’ files.

 

1.2     STATEMENT OF PROBLEM

Drug  procurement,  tracking,  distribution  and  information  management  in  this
regard are routine processes carried out in various hospitals across Nigeria. It is a
common place to observe that these routine processes are still preformed manually
or are minimally computerized  even in our Teaching  Hospitals. This manual
approach to these routine operations has a lot of problems associated with it,
ranging  from  poor  handling  of  drug  data  of  patients,  lack  of  good  storage
information system for drugs and drug dispensary, delays, to the difficulty in
retrieving  information  on  drugs  and  patients’  records.    In  view  of  all  these
problems, it becomes necessary to develop a computer based drug information
management system and distribution tracking system. This is what this research
project is set to address by computerizing the routine processes in our hospitals and
in particular that of Pharmacy Department of UNTH Enugu.

 

 

 

12

 

 

 

 

 

1.3     OBJECTIVES OF THE STUDY

The aim of this research project is to design and implement a computerized drug information  management  system,  drug  procurement  and  distribution  tracking system. This includes:

 

(i). To order for drugs without mistake of procuring more than required.

 

(ii). To take good stock of drugs.

 

(iii). To prevent dispensary of expired drugs

 

(iv). To ensure accurate keeping of records of drugs

 

1.4      SIGNIFICANCE OF THE STUDY

 

The benefits derivable from this work include the following:

 

(i) It will provide reliable healthcare services.

(ii) It will guarantee hospital management and patients of genuine and safe
drugs.

 

(iii)    It will ensure an efficient and standard drug dispensary system.

(iv)   It  will  provide  a data  base  for  stock  taking  of  drugs  procured  and
dispensed any moment.

 

13

 

 

 

 

 

1.5     SCOPE OF THE STUDY

This  research  work  will  cover  only  the  Pharmaceutical  Department  of  the University of Nigerian Teaching Hospital (UNTH) Enugu. It will present an up to date and comprehensive design of the following:

(i)    Planning and control system which includes inventory control and drug
distribution

(ii)     Drug procurement procedure in a hospital.

(iii)   The expiry status of each drugs at any point in time

(iv)  The Database of all kinds, types and names of some drugs that would be
store and operate on.

1.6     ASSUMPTION

It is assumed that all the information gathered with the respect to inventory control
is correct as implemented by the university of Nigerian teaching hospital (UNTH)
Enugu.

 

 

 

 

 

 

 

 

 

 

 

 

 

14

 

 

 

 

 

1.7    LIMITATIONS OF THE STUDY

  1. Time constraint; There is limited time go and meet the hospital pharmacist for proper information.
  2. Due to the sensitive nature of organizational information, there was reluctance to
    release vital information which may jeopardize the security of the organization.

 

1.8 PROJECT REPORT ORGANIZATION

This research project covers almost all you need to know about drug procurement and distribution tracking system. Chapter one is the introduction and it covers the statement of problem, objectives of the study, significance of the study, scope of the study, assumption, limitations of the study and definition of terms. Chapter two is the literature review; it gives the detailed meaning of every associated word in my topic. Chapter three is the design and methodology; this involves the operation of the existing system and the method used. Chapter four is the system analysis and implementation; which talked about the operation of the proposed system. Chapter five is the summary, recommendation and conclusion.

 

 

 

 

 

 

 

 

 

15

 

 

 

 

 

1.9     DEFINITION OF TERMS

Database; A collection of logically related data to meet the information need of organization.

DBMS; Database    Management Software that enable the user to define, maintain Control the database.

 

Application Program; A computer program that interacts with the database.

MENU; This is a list of options presented on the screen with each option identified by short code followed by longer description of its purposes.

Drug; It is referred to as a medicine    or chemical substances that are administered to Patients    for curative measures.

Pharmacy; A placed in a hospital where medicine or chemical substances are kept, stored and prepared.

Flowchart; A diagram that shows connection between the different stages of process of the system.

Primary Key; The candidate key that is selected to identify the individual within the relation

 

 

 

 

16

 

 

 

Foreign Key; An attribute or a set of attributes within one relation that matches the candidate key

 

Relation; A relation is a named table with columns and rows

 

Attribute; An attributes is a named column of a relation

 

Domain; A set of allowable values for one or more table

Null; it  represents a value for an attribute that is  currently unknown or not applicable

Database design; The process of creating a design that will support emprise mission statement and mission required database e system.

Software: These are program for computer which allows certain specific task to be accomplished e.g. word process etc.

Hardware: Computer equipment used to perform input processing and system output activates.

Management information system: collection of people, database, and devices produced to use in providing routine information to manager and decision makers of the organization.

DOWNLOAD COMPLETE WORK

DISCLAIMER: All project works, files and documents posted on this website, eProjectTopics.com are the property/copyright of their respective owners. They are for research reference/guidance purposes only and some of the works may be crowd-sourced. Please don’t submit someone’s work as your own to avoid plagiarism and its consequences. Use it as a reference/citation/guidance purpose only and not copy the work word for word (verbatim). The paper should be used as a guide or framework for your own paper. The contents of this paper should be able to help you in generating new ideas and thoughts for your own study. eProjectTopics.com is a repository of research works where works are uploaded for research guidance. Our aim of providing this work is to help you eradicate the stress of going from one school library to another in search of research materials. This is a legal service because all tertiary institutions permit their students to read previous works, projects, books, articles, journals or papers while developing their own works. This is where the need for literature review comes in. “What a good artist understands is that nothing comes from nowhere. The paid subscription on eProjectTopics.com is a means by which the website is maintained to support Open Education. If you see your work posted here by any means, and you want it to be removed/credited, please contact us with the web address link to the work. We will reply to and honour every request. Please notice it may take up to 24 – 48 hours to process your request.

WeCreativez WhatsApp Support
Administrator (Online)
Hello and welcome. I am online and ready to help you via WhatsApp chat. Let me know if you need my assistance.