ABSTRACT
The efficient management of pharmaceutical inventory is crucial for the effective operation of
any pharmacy and the overall healthcare delivery system. However, many pharmacies still rely
on manual methods for recording stock levels, sales transactions, and expiry dates, leading to
inefficiencies, data redundancy, and financial losses due to expired drugs. This project focuses
on the design and implementation of a computerized Pharmacy Stock and Database System to
address these challenges. The system was developed using the System Development Life Cycle
(SDLC) methodology and utilizes a Relational Database Management System (RDBMS) to ensure
data integrity and security. Key features of the system include automated stock updates, point-
of-sale processing, expiry monitoring, and real-time report generation. By transitioning from a
manual to a digital system, the proposed solution enhances the accuracy of inventory records,
reduces the workload of pharmacy staff, and provides management with timely data for
decision-making. The implementation of this system demonstrates that information technology
can significantly optimize pharmaceutical operations, ensuring that drugs are available, safe,
and properly accounted for.
INTRODUCTION
1.1 Introduction
The healthcare industry relies heavily on the efficient management of
pharmaceutical products to ensure the well-being of patients. Pharmacies serve as
the critical link between pharmaceutical manufacturers and the public. As the
demand for healthcare services grows, the volume of drugs and medical supplies
that pharmacies must handle increases significantly (World Health Organization,
2011). Managing these large inventories manually is prone to human error,
inefficiency, and delays. Consequently, there is a pressing need for automated
systems that can handle stock management, sales tracking, and data retrieval with
speed and accuracy. This project focuses on the design and implementation of a
Pharmacy Stock and Database System to modernize pharmacy operations, ensuring
that drugs are available when needed and that records are securely maintained.
1.2 Background of the System
Traditionally, pharmacies have relied on paper-based record-keeping systems or basic
spreadsheet software to manage their inventory and sales. In such manual systems,
pharmacists record stock entries, expiry dates, and sales transactions by hand (Adebayo,
2013). While this method may work for very small establishments, it becomes
cumbersome as the business grows. Retrieving specific transaction history or checking
the stock level of a particular drug requires searching through stacks of files, which is
time-consuming. With the advent of Information Technology (IT), database management
systems have become the standard for inventory control. A digital pharmacy system
utilizes a database to store all information regarding drugs, suppliers, and transactions,
allowing for real-time updates and easy data access via a user-friendly interface (Laudon
& Laudon, 2020).
1.1 Problem Statement Despite the critical role pharmacies play in healthcare, many still
operate using inefficient manual processes. These manual systems present several
challenges:
1. Time Consumption: Calculating daily sales and updating stock levels manually takes
valuable time that could be spent serving patients (Okafor, 2015).
2. Human Error: Manual data entry is susceptible to mistakes, such as recording wrong
quantities, dispensing expired drugs, or incorrect billing.
3. Data Loss and Security: Paper records can be easily lost, damaged, or misplaced due to
fire, theft, or mishandling. Furthermore, there is no adequate security to prevent
unauthorized access to sensitive patient or drug information.
4. Lack of Real-Time Information: Management cannot instantly determine which drugs are
running low (re-order level) or which drugs are expiring soon, leading to stockouts or
financial losses due to expired goods.
5. Inefficient Reporting: Generating monthly or annual reports requires tedious manual
compilation of data, delaying decision-making processes.
6. 1.4 Purpose of the Project The purpose of this project is to design and implement a
computerized Pharmacy Stock and Database System that replaces the manual method of
inventory management. The system aims to automate the daily operations of a
pharmacy, including stock entry, sales processing, and report generation, thereby
enhancing accuracy, efficiency, and data security (Isiaka, 2015).
7. 1.5 Project Objectives The specific objectives of this project are:
1. To design a centralized database that stores detailed information about drugs (name,
dosage, price, expiry date, quantity).
2. To develop a user interface that allows pharmacy staff to easily add, update, and delete
drug records.
3. To implement a feature that automatically alerts users when a drug is about to expire or
when stock levels fall below a minimum threshold.
4. To create a sales module that processes transactions, updates stock levels automatically,
and generates receipts.
5. To generate accurate reports (daily sales, inventory reports, and expiry reports) to assist
management in decision-making.
8. 1.6 Project Scope The scope of this project covers the development of a stock
management system tailored for a retail pharmacy. It includes:
Inventory Management: Categorizing drugs, managing suppliers, and tracking stock
levels.
Point of Sale (POS): Processing sales and calculating totals.
Expiry Monitoring: Tracking the shelf life of medications.
User Management: Differentiating access levels between an Administrator and a regular
user (Pharmacist).
Reporting: Generating summaries of sales and inventory status.
9. The project focuses specifically on the software aspect (the application and the
database). It does not cover hardware integration with barcode scanners or automated
dispensing machines, although it will be designed to be compatible with such future
upgrades.
10. 1.7 Significance of the Project The successful implementation of this project will benefit
several stakeholders:
Pharmacy Owners/Management: It provides a clear overview of business performance,
helps in financial tracking, reduces losses due to expired drugs, and improves inventory
planning (Waters, 2014).
Pharmacists/Staff: It reduces the workload and stress associated with manual
calculations, allowing them to focus more on patient care and consultation.
Patients/Customer: It leads to faster service, accurate billing, and assurance that the
drugs they receive are not expired.
Academic Researchers: This project serves as a reference material for future researchers
who wish to study or improve upon pharmacy management systems.
11. References
12. Adebayo, O. (2013). The impact of computerization on business operations in Nigeria.
Journal of Information Technology Management, 4(1), 15-23.
13. Isiaka, A. (2015). Design and implementation of an automated inventory control system
for a pharmacy. Unpublished Undergraduate Project, University of Lagos.
14. Laudon, K. C., & Laudon, J. P. (2020). Management information systems: Managing the
digital firm (16th ed.). Pearson Education.
15. Okafor, C. (2015). Problems of manual inventory management in small and medium
enterprises. International Journal of Business and Commerce, 3(5), 1-12.
16. Waters, D. (2014). Inventory control and management (2nd ed.). John Wiley & Sons.
17. World Health Organization. (2011). The role of the pharmacist in the health care system.
WHO Press.