DESIGN AND IMPLEMENTATION OF A PHARMACEUTICAL MANAGEMENT SYSTEM


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 

.


TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.COM

Researchwap.com is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.com guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.com is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.com" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.