Project Topics Seminar Topics School of Nursing Exam PDF Sign Up
Search Topic
PARKLYN
ERVICES
· RC: 2994849
Design and Implementation of a Computer Based Drug Purchasing System for a Pharmaceutical Organisation
WhatsApp Channel

Design and Implementation of a Computer Based Drug Purchasing System for a Pharmaceutical Organisation


This page presents an excerpt of the available research material, including the Preliminary Pages, Table of Contents, Abstract, Chapters One to Five, and References. It provides a comprehensive overview of the study, enhancing readability and accessibility for students, and researchers seeking complete material on the topic stated above.


ACKNOWLEDGEMENT


I am profoundly grateful to everyone who contributed to the successful completion of this project. I am especially grateful to my Supervisor (Name), the Head of Department (Name), and the Lecturers in the Department of Computer Science (CS) for their invaluable guidance and support. I also acknowledge the contributions of authors and scholars whose works on Design and Implementation of a Computer Based Drug Purchasing System for a Pharmaceutical Organisation (A Case Study of Juhel Pharmceuticals Company Ltd Emene) provided essential insights. Special thanks go to my study area (and any funding organizations, if applicable) for their financial assistance. I am equally thankful to stakeholders, including mentors, teachers, and colleagues, for their encouragement and support. Finally, I deeply appreciate my family and friends for their patience and unwavering support throughout this journey. Your contributions have been instrumental in making this research a reality.




PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION

  • 1.1 Introduction
  • 1.2 Background of Study
  • 1.3 Statement of Problem
  • 1.4 Aim and Objectives of the Study
  • 1.5 Significance of Study
  • 1.6 Scope of Study
  • 1.7 Limitations of the Study
  • 1.8 Definition of Terms

CHAPTER TWO

LITERATURE REVIEW

  • 2.1 Introduction
  • 2.2 Conceptual Review of Drug Purchasing Systems
  • 2.3 Overview of Computer-Based Information Systems
  • 2.4 The Role of ICT in Pharmaceutical Management
  • 2.5 Drug Inventory and Procurement Process in Pharmaceutical Organisations
  • 2.6 Challenges in Manual Drug Purchasing Systems
  • 2.7 Existing Systems and Their Limitations
  • 2.8 Benefits of Computerizing Drug Purchasing Operations
  • 2.9 Review of Related Works
  • 2.10 Summary of Literature Review

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

  • 3.1 Methodology Adopted
  • 3.1.1 Problem Identification Using SSADM
  • 3.2 Analysis of the Existing System
  • 3.2.1 Dataflow of the Existing System
  • 3.2.2 Disadvantages of the Existing System
  • 3.2.3 Weakness of the existing System
  • 3.3 Feasibility Study
  • 3.3.1 Economic Feasibility
  • 3.3.2 Technical Feasibility
  • 3.3.3 Operational Feasibility
  • 3.4 Analysis of the Proposed System
  • 3.4.1 Data Flow Diagram of the Proposed System
  • 3.4.2 Advantages of the Proposed System
  • 3.4.3 Justification of the Proposed System
  • 3.5 Functional Requirements
  • 3.5.1 Use Case Diagram of the Admin / User Privileges
  • 3.6 Data Requirements
  • 3.7 High Level Model of the Proposed System

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

  • 4.1 Objectives of the Design
  • 4.2 Cohesion and Decomposition High level Model
  • 4.3 Control Center / Overall Dataflow Diagram
  • 4.3.1 Proposed System Operation Flowchart
  • 4.4 System Specification and Design
  • 4.4.1 Input and Output Specification
  • 4.4.2 Database Specification and Design
  • 4.4.3 Data Dictionary
  • 4.5 Choice and Justification of Programming Language
  • 4.6 Program Documentation
  • 4.7 Implementation Techniques
  • 4.7.1 System Testing
  • 4.8 Programming Module Specification
  • 4.8.1 Installation
  • 4.8.2 Security Design Specification
  • 4.8.3 System Architecture
  • 4.9 Computer Hardware Minimum Requirement
  • 4.10 Software Requirement
  • 4.11 Personnel / User Training
  • 4.12 File Maintenance Module
  • 4.13 Discussion of Findings

CHAPTER FIVE

SUMMARY, CONCLUSION AND RECOMMENDATION

  • 5.1 Introduction
  • 5.2 Summary
  • 5.3 Conclusion
  • 5.4 Recommendation

REFERENCES

APPENDIX A - “SOURCE CODE”

APPENDIX B - “OBJECT PROGRAM”



ABSTRACT


Computer-based drug purchasing is the automated process of procuring pharmaceutical products and raw materials required for their production, inventory management, and distribution. The aim of this study is to design and implement a computer-based drug purchasing system for Juhel Pharmaceuticals Company Ltd, Emene. The motivation that led to the implementation of the proposed system is that the manual documentation process often results in errors, data duplication, and incomplete records, making it difficult to track purchases and supplier history accurately. The methodology adopted in this study is the object oriented analysis and design methodology (OOADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The research developed a computer-based drug purchasing system that automates drug order processing, supplier management, and stock updates. The system was designed using PHP and MySQL, providing real-time updates on drug availability and facilitating accurate record keeping. The analysis of post-implementation feedback indicated that 90% of users observed improved speed in transaction processing, and 85% noted a reduction in record duplication and human error. The proposed system implementation will provide accurate data and reports that will support better planning, forecasting, and decision-making in procurement activities. It will also simplify routine tasks, reduce paperwork, and improve workflow efficiency by automating key purchasing operations. The expected result is a Computer Based Drug Purchasing System for a Pharmaceutical Organisation that will automate the process of purchasing drugs within the organization, thereby reducing manual errors and delays.




1.1 Introduction

A computer-based system is an organized combination of hardware, software, data, and procedures designed to process information automatically and efficiently (Laudon & Laudon, 2020). In the context of modern organizations, computer-based systems are essential tools that aid in the management, storage, and retrieval of data with high levels of accuracy and speed. Drug purchasing is an integral part of pharmaceutical operations that involves the acquisition of drugs, raw materials, and medical supplies necessary for production and distribution. According to Nwankwo (2019), the efficiency of the purchasing system determines the overall productivity of pharmaceutical firms, as delays or inaccuracies in procurement often lead to shortages, increased costs, and customer dissatisfaction. Traditionally, many pharmaceutical organizations rely on manual procedures for recording and tracking purchases, which often result in data redundancy, human error, and difficulty in generating timely reports.

As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitation of the study and Definition of technical terms.


1.2 Background of Study

A computer-based system is a technological innovation that integrates hardware, software, and database components to perform data processing, management, and retrieval efficiently. According to Laudon and Laudon (2020), computer-based systems have revolutionized how organizations conduct their daily operations by automating tasks that were previously handled manually. In today's dynamic business environment, the adoption of computerized systems in organizations has become essential for enhancing operational efficiency, reducing redundancy, and promoting transparency. Within the pharmaceutical industry, where data accuracy and timely decision-making are critical, the design and implementation of a computer-based drug purchasing system play a significant role in achieving operational excellence.

Procurement, which involves the acquisition of goods and services necessary for production and distribution, is one of the most crucial functions in any organization. Nwankwo (2019) asserted that effective procurement management determines the efficiency of pharmaceutical operations because it ensures the timely availability of drugs and raw materials needed for production. However, many pharmaceutical companies in developing countries still rely heavily on manual purchasing systems, which often result in inefficiencies such as delays, data loss, and errors in record-keeping. Okoro (2019) reported that manual procurement processes expose organizations to problems such as inaccurate inventory tracking, mismanagement of funds, and lack of accountability in the purchasing department.

Eze and Umeh (2021) affirmed that the use of computerized systems in drug procurement helps to reduce human error, improve accuracy in data handling, and promote transparency in purchasing activities. The system provides a centralized platform that stores supplier information, purchase orders, and payment records, allowing for quick access and easy retrieval of data when needed. On the other hand, the absence of such automation leads to time wastage, duplication of effort, and lack of coordination among departments responsible for procurement. Okafor and Eze (2020) stated that pharmaceutical organizations with computerized purchasing systems experience improved workflow management, better supplier relationship management, and faster decision-making processes.

Furthermore, technology-driven systems are not only limited to improving efficiency but also enhance control and accountability. Adebayo (2022) contended that automation in procurement processes ensures that management can monitor transactions in real time, detect irregularities, and make informed financial decisions. This form of transparency is particularly important in the pharmaceutical sector, where regulatory compliance and quality assurance are paramount. Olayinka (2021) reported that computer-based procurement systems contribute significantly to maintaining an accurate database of transactions and assist organizations in meeting industry standards and government regulations.

In Nigeria, pharmaceutical companies such as Juhel Pharmaceuticals Company Ltd, Emene, face challenges in maintaining efficient purchasing systems due to manual operations. These challenges include poor data management, lack of timely reporting, and the risk of stockouts or overstocking of essential drugs. Nwosu (2020) stated that implementing a computerized purchasing system addresses these challenges by integrating data management and reporting tools that provide real-time visibility into inventory and supplier performance.

The challenges encountered that led to the execution of the research work is that, the manual approach usually involves the use of paper documents to record transactions, supplier information, and inventory levels. According to Okoro (2019), manual procurement systems in pharmaceutical organizations lead to delays in drug supply and mismanagement of purchasing records, which adversely affect customer satisfaction and organizational productivity. This study is set against the backdrop of developing a reliable and efficient computer-based drug purchasing system for Juhel Pharmaceuticals Company Ltd, Emene, to enhance accuracy, transparency, and efficiency in the drug procurement process.


1.3 Statement of Problem

The existing manual drug purchasing system at Juhel Pharmaceuticals Company Ltd, Emene, has several operational and administrative challenges that have affected efficiency and accountability. These problems include:

  1. The manual documentation process often results in errors, data duplication, and incomplete records, making it difficult to track purchases and supplier history accurately.
  2. The lack of real-time data accessibility causes delays in decision-making, as management depends on manually compiled reports that are often outdated.
  3. Poor inventory tracking leads to situations of overstocking or stock shortages, affecting the smooth flow of production and distribution.
  4. Misplacement or loss of records is common due to the paper-based filing system, creating inconsistencies and making auditing difficult.
  5. The absence of an automated reporting system makes it challenging to analyze purchasing trends, supplier performance, and expenditure patterns.
  6. Time wastage and inefficiency occur as staff manually process purchase orders and approvals, slowing down the overall procurement cycle.

1.4 Aim and Objectives of the Study

The main aim of this study is to design and implement a computer-based drug purchasing system for Juhel Pharmaceuticals Company Ltd, Emene. The specific objectives are to:

  1. Create a computerized system that will automate the process of purchasing drugs within the organization, thereby reducing manual errors and delays.
  2. Develop a reliable and user-friendly software that will manage supplier records, drug inventories, and purchase transactions efficiently.
  3. Design a functional database structure that will store and retrieve purchasing information securely and accurately.
  4. Implement an interactive interface that enables staff to process purchase orders, generate reports, and monitor procurement activities in real time.
  5. Develop a system that will enhance decision-making by providing analytical summaries and reports on drug purchasing trends and supplier performance.

1.5 Significance of Study

The deployment of the proposed system will hold significant relevance in the following ways.

  1. The system will provide accurate data and reports that will support better planning, forecasting, and decision-making in procurement activities.
  2. It will simplify routine tasks, reduce paperwork, and improve workflow efficiency by automating key purchasing operations.
  3. It will enhance communication and transaction accuracy, ensuring timely order processing and payment transparency.
  4. The research will ensure the availability of drugs by improving inventory control and preventing stock shortages.
  5. The outcome of the implemented system will serve as a reference model to researchers and software developers for future studies and development of related procurement systems across industries.

1.6 Scope of Study

The scope of the research is focused on the design and implementation of a computer-based drug purchasing system for Juhel Pharmaceuticals Company Ltd, Emene, Enugu State, Nigeria. The system is limited to automating core procurement functions such as order processing, supplier management, and inventory record maintenance.


1.7 Limitations of the Study

During the course of this study, many things militated against its completion, some of which are:

  1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
  2. Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this research work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
  3. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

1.8 Definition of Terms

Computer-Based System:

According to Laudon and Laudon (2020), this refers to a system that uses computer hardware and software to process, store, and manage information efficiently.

Drug Purchasing:

As stated by Nwankwo (2019), drug purchasing is the process of acquiring pharmaceutical products and raw materials required for manufacturing and distribution.

Procurement System:

Okoro (2019) defined it as an organized method for sourcing, ordering, and acquiring goods and services needed by an organization.

Automation:

Adebayo (2022) reported that automation involves the use of technology to perform tasks with minimal human intervention, increasing efficiency and accuracy.


CHAPTER TWO

LITERATURE REVIEW


2.1 Introduction

This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the conceputal review, theoretical framework, the review of related literature …


How to Download the Complete PDF Material (Table of Contents, Abstract, Chapter 1-5, and References)


Above is a preview excerpt of the full study on “Design and Implementation of a Computer Based Drug Purchasing System for a Pharmaceutical Organisation (A Case Study of Juhel Pharmceuticals Company Ltd Emene)”. The complete material, including all five chapters, is available for download upon request. Get in touch with us here!

Download Material (Docx)