DESIGN AND IMPLEMENTATION OF A PHARMACEUTICAL MANAGEMENT SYSTEM
ABSTRACT
Web based Pharmacy management system is an online management system that is designed to improve accuracy and to enhance safety and efficiency in the pharmaceutical store, It is a computer based system which helps the Pharmacist to improve inventory management, cost, medical safety. It also involves manual entry upon arrival of new batches of drugs and upon drug movement out of the pharmacy for a certain period, e.g. every month, the pharmacist may want to generate report for the movement of drugs in and out of the pharmacy, getting information about the drugs e.g. expiry date, date purchased, number of drug type left, location of a drug in the pharmacy.
This project work will prompt the pharmacist about drugs that are close to expiry, preventing those drugs from being sold, preventing congestion in the pharmacy and also providing solution to the earlier stated problems.
Web based Pharmacy management system would be designed to help make the rigorous activities carried out in a pharmacy much easier by providing the statistics of drugs in stock, monitoring drug movement in the pharmacy and ensuring effective policing of the activities in the pharmacy.
Table of Content
Title Page
Front page
Certification i Dedication ii Acknowledgement iii Abstrast iv Table of contents v List of figures viii
CHAPTER ONE
1.1 Introduction 1
1.2 Statement of the problems 2
1.3 Aim and objectives of the study 3
1.4 Significance of the study 3
1.5 Scope and Limitations of the study 4
1.6 Research Methodology 4
1.7 Definition of Terms 4
1.8 Chapter Layout 5 CHAPTER TWO
2.1 Review of closely related works 6
2.2 Content Management System 7 2.3 Pharmacy Inventory Management Systems 8
2.4 Pharmacy practice in the past 9
2.5 The History of Pharmacy 10
2.6 The Present day Pharmacy 12
2.7 The Future of Pharmacy 13
2.8 The physical layout or appearance of tomorrow's pharmacies 14
CHAPTER THREE
3.0 Introduction 16
3.1 System analysis 16
3.2 analysis of existing system 16
3.3 Analysis of proposed system 17
3.4 Requirement Definition 18
3.5 Method of information gathering 18
3.6 System Design 18
3.7 System modelling 19
3.8 System Flowchart 19
3.9 Methodology 23 CHAPTER FOUR: Result and discussion 24
4.0 SYSTEM DEVELOPMENT 24 4.1 SOFTWARE IMPLEMENTATION 24
4.2 System Testing and Debugging 25
4.3 DATABASE SPECIFICATION 25
4.4 SYSTEM MAINTENANCE 26
4.5 HOME PAGE 26
4.6 USER LOGIN PAGE 28
4.7 ADMIN PAGE 29
4.8 PHARMACIST PAGE 30
4.9 MANAGER PAGE 31
4.10 CASHIER PAGE 32 CHAPTER FIVE
5.0 Summary 33
5.1 Conclusion 33
5.2 Recommendation 34
5.3 QR – Codes 34
5.4 References 36 APPENDIX 38
LIST OF FIGURES
Figures Page
Figure 3.1: System flowchart 19 Figure 3.2: System Use Case Diagram 22 Figure 4.1: Home page 26 Figure 4.2: User login page 28 Figure 4.3: Admin page 29 Figure 4.4: pharmacist page 30 Figure 4.5: Manager page 31 Figure 4.6: cashier page 32
CHAPTER ONE
INTRODUCTION
Background to the study
Applications for health-care delivery need a robust and safe system for providing medicine. Stock-outs, especially for chronic diseases, can have serious negative effects on patient care. (Kumar &Bano, 2017). A term used today to describe the usage of information and communication technology in the health sector is the Electronic Pharmacy System.
Currently, there have been a significant growth implementing the pharmacy application and integrating it with data gotten from the existing systems; this could help to increase the accuracy and ease of the creation of medical needs and stock management. Besides, the number of stock-outs of medical supplies will decrease (Fung et al., 2013).
The Electronic Pharmacy System (EPS) is a web-based sales program for medication that uses software and technology to achieve its objectives and carry out its work more accurately. In general, the growing popularity of computers and gadgets has not delayed the birth of new revolutionary methods in the pharmaceutical management system in any way (Ferrández et al., 2017).
Computers have been an essential part of the lives of many people these days because of the machines' flexibility and how much they can do with very little effort (Yousif et al., 2017). It has become possible to perform tasks in seconds that would have taken hours and even days in the past. In very little time, the creation of the web and the Internet other services such as search engines (Google being a prime example) have made it possible to
search for the most distant stuff possible (Shepherd & Peterson, 2011).
The portability of computer systems has also helped to make data more portable than it was in the past.The Web-based pharmacy management system is an online management system developed to enhance accuracy and improve pharmaceutical store safety and productivity (Jabar, 2015). It is a computer-based system that helps improve inventory management, expense, and medical safety for the pharmacist. During the opening of stock and sales transactions, the device allows the customer to enter an output and expiry date for a specific product or drug (Goldberg et al , 2011).
Often the system will report the list of expired items after a given date before the product finally expires. It also requires manual entry for a certain period after the delivery of new batches of drugs and drug movement from the pharmacy, e.g. every month, the pharmacist will want to produce reports on the drug movement in and out of the pharmacy, collecting information on the drugs, e.g. expiry date, purchased date, number of drug type left, location of a drug in the pharmacy (Holm et al., 2015).
The manual method in the pharmacy is currently being used. It allows the pharmacist to track each medication available in the pharmacy manually This usually leads to mistakes as the pharmacist's workload increases (Mao et al., 2008). Due to the size and quality service of the pharmacy, the pharmacy has a very large customer base (Muallem et al., 2015). Many of these clients prefer to visit the pharmacy for services when they close off work. The number of customers patronizing the pharmacy is growing at this stage, rendering the pharmacists' workload even more tedious (Martin, 2011). This condition makes it impossible for the pharmacist to handle clients within a limited period. Meanwhile the pharmacist needs to ensure quality satisfaction in services to keep their
customers.
The above factors contribute to delays in supplying consumers with services, thus slowing down sales and losing the chance of losing important customers in the end.
1.2 STATEMENT OF THE PROBLEM
In filing cabinets, pharmacy administration maintained paper records. It would be boring, dangerous and difficult to keep track of inventories of drugs in the shop, expiry date, quantity of drugs available depending on the categories and their functions, to operate a very large pharmacy with paper records. To replenish the already dwindling stock, the pharmacist has to order medicines. Moreover, the ordering of drugs is carried out manually. As the pharmacist has to go through the stock, balance and make a rough calculation of the sum to be ordered based on figures, considerable time is allocated for writing the order. Since they expire, medications are not meant to be used. This project work would enable the pharmacist to address drugs that are near expiry, avoid the selling of those drugs, prevent congestion in the pharmacy, and provide a solution to the problems mentioned earlier.
1.3 Aim and Objectives
The aim of this research is to design a web based pharmacy management system for H- Medix pharmacy that will speed up the disbursement of medicines for patients through safety process. The following are the objectives:.
i. To design a web based pharmaceutical system for H-Medix pharmacy.
ii. To design a databasefor H-Medix.
iii. To evaluate the developed system.
1.4 Significance of the Study
The enhancement of the web-based pharmaceutical system will be of significant benefit to H-Medix pharmacy. Data from the web-based pharmaceutical system will enhance both quick delivery of services and the issue of congestion within the pharmacy environment.
Since a web-based pharmacy system can have a more precise image of whether a certain prescription is available in the store or otherwise and, based on empirical evidence, correctional services will be in place. Similarly, the level of knowledge provided by the web-based pharmacy management system will help patients verify the availability of medications prescribed to them by their doctors and help the pharmacy management keep inventory of the shop.
1.5 Scope and Limitation
The scope of this research work is limited to the activities of H-Medix pharmaceutical store, which includes improving health outcomes, reduce hospital and long-term care admissions, enhance access and care in the Estate and surrounding communities and ensuring best use of resources. The use of an internet and computer based management system for improving the efficiency of a pharmacy is needed and it is an essential part of any modern continuously evolving society. The machine would not be able to manage the prescribing of medications, the contact between drugs and drugs. Contraindication and polypharmacy in a prescription would not be treated by the system;
1.6 RESEARCH METHODOLOGY
A description of how the web-based pharmacy management system will be developed is
provided in the research method used for this project work.
Therefore, the method used in the design and collections of information from various sources are as follows:
i. Studying the present system in detail and the organizational style.
ii. Knowing and understanding the input and output processes of the existing system.
1.7 DEFINITION OF TERMS
System: This is a complex collection of interrelated components that work together to achieve certain goals.
Drug interaction: is a situation in which, when both are administered together, a substance (usually another drug) affects the activity of a drug.
Polypharmacy: is the use by a patient of multiple medications, particularly when a patient is using too many forms of medication, i.e. when more medications are prescribed than clinically warranted.
Contraindication: is the condition or factor that serves as a reason to withhold a certain medical treatment.
1.8 CHAPTER LAYOUT
This project's chapter layout is outlined sequentially beginning with Chapter one, consisting of the Introduction, Study Background, Problem Statement, Aims and Objectives, StudySignificance, Methodology of Research, Scope, Limitation, and Terms Definition.
Chapter 2 consists of introduction, Literature review of the project, an overview of pharmacy management in the past, at present and include the benefits of pharmacy
management.
Chapter 3 deals with the analysis of the existing system, and would discuss the description of the current system, the issues of the current system, the description of the proposed system, and the benefits of the proposed system. System.
Chapter 4 The system design would include an input and output design consisting of system design, system implementation and system documentation under the system design.
Chapter 5 A review, conclusion and recommendation will be included. It consists of the project report overview, suggestions based on the project study, and
.