DESIGN AND IMPLEMENTATION OF A COMPUTERISED DRUG VERIFICATION AND MANAGEMENT SYSTEM (A CASE STUDY OF NATIONAL AGENCY FOR FOOD AND DRUG ADMINISTRATION)
ABSTRACT: This project was centered on design and implementation of computerized drug verification and management system. The current process of verifying and managing drugs by NAFDAC is being operated manually and due to this procedure numerous problems are been encountered. Thisdesign was taken to computerize the manual process in order to check these problems. The problems were identified after series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The system was designed using PHP programming language. This language was chosen because of its easy syntax and features for developing web based applications.TABLE OF CONTENTSTitle Page - - - - - - - - - iApproval Page - - - - - - - - iiDeclaration - - - - - - - - iiiDedication - - - - - - - - - ivAcknowledgement - - - - - - - vAbstract - - - - - - - - - viTable of Contents - - - - - - - viiCHAPTER ONE – INTRODUCTION1.1.0 General Introduction - - - - -- -1.2.0 Introduction - - - - - -- -1.3.0 Problem definition- - - - -- -1.4.0 Objective of study - - - - - - -1.5.0 Research justification - - - - -- -1.6.0 Research methodology- - - - -- -1.7.0 Scope and limitation of study - - -- -1.8.0 Chapter layout - - - - - - -CHAPTER TWO – REVIEW OF RELATED LITERATURE2.1 Introduction - - - - - - - - -2.1 The meaning of ethical drugs and its relationship with herbal medicine (drug interactions)- - - - - - - - 2.2 The rationale for drug sales in Nigeria- - - - -2.3 Fake and counterfeit drugs in the healthsector- - - -2.4 Fake/counterfeit drugs defined- - - - - - -2.5 Major reported tragedies associated withsubstandard and fake/counterfeit drugs- - - - - - - - -2.6 The implications of counterfeit/fakedrugs- - - - -2.7 Factors that encourage drugcounterfeiting- - - -2.7.1 Chaotic drug distribution system- - - - -2.7.2 Inadequate cooperation fromgovernment agencies and amongprofessional groups- - - - - - - - -2.8 he role of doctors in eliminatingfake/counterfeit medicines2.9 he drug situation in Nigeria- - - - - - - 2. 1.0 Overview- - - - - - - - --184.108.40.206 Cloud technology- - - - - - - - -2. 1.0.2. Sproxil - - - - - - - - - -220.127.116.11 Hp labs and mpedigree networks - - - - - 18.104.22.168 Rapid alert systems and product recalls - - - -22.214.171.124 Drug product information system - - - - -126.96.36.199 Rss technology and the social web- - - - -CHAPTER THREE – RESEARCH METHODOLOGY3.1 Introduction - - - - - - - - -3.2.0 System requirement specification- - - - - -3.3.0 System design- - - - - - - - -188.8.131.52 Logical design- - - - - - - - -184.108.40.206 Structure of database- - - - - - - -3.4 Activity Diagram- - - - - - - - -CHAPTER FOUR – DATA PRESENTATION AND ANALYSIS SYSTEM IMPLEMENTATION4.1.0 Introduction- - - - - - - - --4.2.0 Features of implementation languages- - - - - 4.3.0 System testing strategies- - - - - - - -4.3.1 Unit test- - - - - - - - ---4.3.2 Integration testing- - - - - - - - -4.4.0 Target computer system requirements- - - - - 4.5.0 Software maintenance issues - - - - - - -4.5.1 Corrective maintenance- - - - - - - -4.5.2 Preventive maintenance - - - - - - - -4.5.3 Adaptive maintenance- - - - - - - -CHAPTER FIVE – SUMMARY, CONCLUSION AND RECOMMENDATION5.0 Introduction - - - - - - - - -5.1 Summary - - - - - - - - - -5.2 Conclusion - - - - - - - - - -5.3 Recommendations - - - - - - - - References - - - - - - - - - -Appendix - - - - - - - - - -CHAPTER ONEINTRODUCTION1.0 GENERAL INTRODUCTION Drug reporting and verification establishments like NAFDAC (National Agency for Food and Drug Administration and Control), require efficient and brilliant technique and flexible system for proper drug management. Their main objective is to ensure every fake drugs producing company are eliminated in Nigeria. In recent years, there has been a rapidgrowth in fake drugs incident which as claim a lot of lives in the country, this predicament has created the need to build an application that will address most of the issues address in this research work. This research work will be of paramount importance to these sectors as it will be design to address most of their challenges.Drug reporting and verification Software easily automates the whole process of drug verification and reporting. Drugs Pharmaceutical Company are register on the system and verification code are generated for each drug production. System users are created by the system admin where each staff is able to login in with the provided authorization and manage his/her account. The system which will be made available to the general public provides a window in which users could type in a drug code to verify the authenticity of that drug. The admin has the sole authority over the system.1.1 INTRODUCTIONChapter one introduces the research work and the problem definition of the research, and to know the aim of this research work, research justification tells us why it is important to research Where agent of NAFDAC find it quite difficult to access register pharmaceutical company and drugs right there on the field.on this topic; it also covers areas like scope and limitation of study which entails the boundary of this work. Definition of terms gives summarize what each chapter entails.1.2 PROBLEM DEFINITION This research work was undertaken to uncover some of the problems with conventionaldrug reporting and verification systems. Here, agents of NAFDACand other drug enforcement agency find it quite difficult to access register pharmaceutical companies . Using these conventional method pose lots of constraint on team member as no team member can access files on the officedatabase while at field work also reports has to be file at the office.1.3 OBJECTIVE OF STUDY In view of the problems mentioned above, this project is aimed at implementing a drug reporting and verificationsystem which will exclusively:⦁ Register every drug produce by every pharmaceutical companyin Nigeria ⦁ Produce and register drugs verification code⦁ Register pharmaceutical all company in Nigeria with each respective trade mark, ⦁ Efficiently handling of fake drug report files and automate the process of drug authentication using appreciate channel.1.4 RESEARCH JUSTIFICATION This research work will provide a more reliable and flexible way of drugs verification and report filing of fake drugs as well as fake pharmaceutical company not authorize to produce and distribute drug in Nigeria. Also eliminate the lag time in file recovery with an inclusion of an asynchronous request incorporated on the system. Furthermore, it will aids structural document, representation and eliminates the tedium of performing monotonous transaction. This research will also contribute to existing literature in this area and will serve as a guild or blueprint for an undergraduate student.1.5 RESEARCH METHODOLOGY This research work “design and implementation of an interactive project management system” will be a web-based application and will be implemented on a relational database system(MySQL). Html(hypertext markup language), css(cascading style sheet) and Jquery will be used to design the web-user interface, php (hypertext preprocessor) will be used as the serve- side script language to link the interface and the database.1.6 SCOPE AND LIMITATION OF STUDY This research work is to develop a system capable of handling all Drugs agencies in Nigeria such as verification and reporting of fake drugs, drugs confirmation code using secure channel, drug enforcement agent .The system will also incorporate in its design a feedback layout between for drug confirmation. The system will not incorporate in its development all the functions of a drug verification and reporting system but will focus only on the aforementioned functionalities. The system will not be responsible for any loss of data if its environment (network/system installed on) is corrupt.1.7 CHAPTER LAYOUTThis section was put in place to explain what each chapter does, chapter one introduces the project to the reader by explaining the problems the project is supposed to solve, objective of the study and research justification is to describe to the reader the purpose and the importance of researching on this topic, research methodology is all about the method used in implementing the research work, scope and limitation describes the boundary of the research work and where the project work can be put into use. Chapter two deals with the literature review and state-of-the-art.This chapter discusses literature review, what people have published related to this research work and their shortcoming, how this present research can improve their shortcomings. Chapter three deals with the system design methodology i.e. collection of tools methods and practices for achieving a task; the requirement specification states the expectation of the system analysis, and design which is the blueprint of what the system would carry out. Chapter four has to do with the implementation, system testing strategies, target computer system requirement, software maintenance etc. Chapter five discusses the recommendations and conclusion part of the research work and how this work can be applied to the problem domain.
SCREEN SHOTS OF THE APPLICATION.