DESIGNIG OF PHARMACEUTICAL STOCK EXPIRING DATE MONITORING SYSTEM: (A CASE STUDY OF UGOLAB PHARMACY KANO)

Abstract

ABSTRACT The spread of substandard, spurious, falsely labeled, falsified, or counterfeit (SSFFC) medicines has been a global concern. Their prevalence increasingly threatens public health by jeopardizing patient safety, leading to treatment failure, contributing to development of drug resistance, and possibly leading to diminished confidence in health systems. This project illustrates the designing and implementation of a Pharmaceutical Stock Expiring Date Monitoring System with stock alert system. The aim of this project is to improve accuracy and enhance safety and efficiency in the pharmaceutical store. This work designed and modeled an Integrative computerized pharmacy inventory system that would have the capability to improve pharmacy drugs quantity tracking, accurate financial records and account balance and give alert for any expired drugs at a specified period. The specific objective of the system is to provide better security for securing and controlling expiring date of medications in the pharmaceutical company, saves space, reduces pharmacy storage footprint, aids in Joint Commission compliance by providing complete audit trail of all transactions and gradually eradicate sales of expired drugs. In this paper, the structured system analysis, design methodology and Unified Modeling Language(UML) used for the model design was adopted. The interface between the front-end and the back-end is through Structure Query Language (SQL) in SQL express and through an application program interface (API) defined in Visual Basic. Net.It was recommended among others that there must be a continuous power supply which ought to be made accessible during the time of operation of the drug store.

Article Preview