PHARMACY MANAGEMENT SYSTEM

By

IBITOYE

Presented To

Department of Computer Science

ABSTRACT

This project is insight into the design and implementation of a Pharmacy Management System. The primary aim of is to improve accuracy and enhance safety and efficiency in the pharmaceutical store. Today management is one of the most essential features of all form. Management provides sophistication to perform any kind of task in a particular form. This is pharmacy management system; it is used to manage most pharmacy related activities in the pharmacy.


TABLE OF CONTENT

COVER PAGE

CERTIFICATION.. I

ACKNOWLEDGMENT.. II

ABSTRACT.. III

TABLE OF CONTENT. IV

TABLE OF FIGURES. VI

LIST OF TABLES. VII

CHAPTER ONE INTRODUCTION .. 1

1.0 INTRODUCTION.. 1

1.1 BACKGROUND OF THE STUDY.. 1

1.2 STATEMENT OF THE PROBLEM - 2

1.3 AIMS AND OBJECTIVES. 2

1.4 SCOPE AND LIMITATION.. 3

1.5 RESEARCH METHODOLOGY.. 4

1.6 DEFINITION OF TERMS. 4

1.7 CHAPTER LAYOUT. 5

CHAPTER TWO LITERATURE REVIEW  - 6

2.0 INTRODUCTION.. 6

2.1 PHARMACY PRACTICE IN THE PAST. 6

2.2 THE PRESENT DAY PHARMACY.. 14

2.3 THE FUTURE OF PHARMACY.. 17

2.4 BENEFITS OF THE PROPOSED SYSTEM - 20

CHAPTER THREE SYSTEM ANALYSIS AND DESIGN .. 21

3.0 INTRODUCTION.. 21

3.1 SYSTEM ANALYSIS.. 21

3.1.1 ANALYSIS OF EXISTING SYSTEM - 22

3.2 REQUIREMENTS DEFINITION.. 23

3.2.1 METHOD OF INFORMATION GATHERING.. 23

3.3 SYSTEM DESIGN.. 24

3.4 SYSTEM MODELLING.. 25

3.5 SYSTEM FLOWCHART.. 25

3.5 DATABASE DESIGN.. 38

CHAPTER FOUR SYSTEM IMPLEMENTATION .. 42

4.0 INTRODUCTION.. 42

4.1 CHOICE OF PROGRAMMING LANGUAGE.. 42

4.3 SYSTEM DOCUMENTATION.. 44

4.4 HARDWARE REQUIREMENT. 44

4.6 DATABASE SPECIFICATION.. 45

4.7 MODULE DESCRIPTION.. 45

4.8 SYSTEM MAINTENANCE.. 53

CHAPTER FIVE CONCLUSION AND RECOMMENDATION .. 55

5.0 SUMMARY.. 55

5.1 CONCLUSION.. 55

5.2 RECCOMMENDATION.. 56

REFERENCES. 57

APPENDIX…………………………………………………………………………..58


LIST OF FIGURES

Figure. 3.3.1 Waterfall Model Of System Development Life Cycle……………….24

Figure 3.5.1 Structure Chart……………………………………………………….27

Figure 3.5.2 System flowchart……………………………………………………..28

Figure 3.5.3 Admin flowchart…………………………………….……………….29

Figure 3.5.4 Supervisor Flowchart…………………………… - …………………30

Figure 3.5.5 Staff flowchart………………………………………………………..31

Figure 4.1 Homepage………………………………………………………… - ..45

Figure 4.2 Admin Login Menu…………………………………………………..46

Figure 4.3 Supervisor Login……………………………………………………..47

Figure 4.4 Staff Login……………………………………………………………48

Figure 4.5 Admin Menu Module…………………………………………….….49

Figure 4.6 Drug Registration Form…………………………………………… - 50

Figure 4.7 Staff registration form………………………………………………..51

Figure 4.8 Store Manager………………………………………………………..52

Figure 4.9 Sales window…………………………………………………………53


LIST OF TABLES

Table 3.1 Administrator Login Table………………………………………………….. 38

Table 3.2 Drug information Table…………………………………………………… - .39

Table 3.3 Supervisor Login Table………………………………………………………40

Table 3.4 Staff Login Table ……………………………………………………………40

Table 3.5 Staff information Table………………………………………………………41



CHAPTER ONE

1.0 INTRODUCTION

Pharmacy management system is a 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 etc.

The system allows the user to enter a manufacturing and expiry date for a particular product or drug during opening stock and sales transaction. The system will also give report showing the list of products expiry after a specified date before the product eventually expires. 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.

At present, manual system is being utilized in the pharmacy. It requires the pharmacist to manually monitor each drug that is available in the pharmacy. This usually leads to mistakes as the workload of the pharmacist increases.

1.1 BACKGROUND OF THE STUDY

Due to the size and quality service of the pharmacy, the pharmacy has a very large customer base. These customers tend to visit the pharmacy for services mostly when they close from work. At this period, the number of customers that patronise the pharmacy is on the increase, thereby making the workload of the pharmacists much more tedious. This case makes it difficult for the pharmacist to attend to customers in a short period.

Meanwhile the pharmacist has to ensure satisfaction in services to keep their customers. The factors mentioned above, results in delay of the services being rendered to the customers, thereby slowing down sales and risk losing valuable customers in the long run.

1.2 STATEMENT OF THE PROBLEM

Pharmacy management has kept paper record in filing cabinets. Managing a very large pharmacy with records on papers will be tedious and difficult to keep track of inventories with regards to the drugs in the store, expiry date, quantity of drugs available based on the categories and their functions.

The pharmacist has to order drugs to replenish the already diminishing stock. In addition, ordering of drugs is being carried out manually. Significant amount of time is allocated for writing the order as the pharmacist needs to go through the stock balance and make rough estimate of the amount to order based on Figures.

Drugs are not supposed to be used after they have expired. This project work will prompt the pharmacist about drugs that are close to expiry, preventing those drugs from being sold and also providing solution to the earlier stated problems.

1.3 AIMS AND OBJECTIVES

The aim of this project is to develop a software for the effective management of a pharmaceutical store that will be able to achieve the following objectives:

- Ensuring effective policing by providing statistics of the drugs in stock.

- Maintaining correct database by providing an option to update the drugs in stock.

- Improving the efficiency of the system by ensuring effective monitoring of services and activities.

- To provide optimal drug inventory management by monitoring the drug movement in the pharmacy.

- To ensure that there exists a level of restricted access based on functionality and role.

- To ensure that the system is user friendly.

- To be able to generate report within a specified period of time.


About E-Project Material Centre


E-Project Material Centre is a web service aimed at successfully assisting final year students with quality, well researched, reliable and ready made project work. Our materials are recent, complete (chapter 1 to Minimum of Chapter 5, with references) and well written.INSTANT ACCESS! INSTANT DOWNLOAD. Simply select your department, choose from our list of topics available and explore your data

Why Students Love to Use E-Project Material ?


Guaranteed Delivery Getting your project delivered on time is essential. You cannot afford to turn in your project past the deadline. That is why you must get your project online from a company that guarantees to meet your deadline. e-Project Topics Material Centre is happy to offer instant delivery of projects listed on our website. We can handle just about any deadline you send our way. Satisfaction Guaranteed We always do whatever is necessary to ensure every customer's satisfaction

Disclaimer


E-Project Topics Material Centre will only provide projects as a reference for your research. The projects ordered and produced should be used as a guide or framework for your own project. The contents of the projects should be able to help you in generating new ideas and thoughts for your own project. It is the aim of e-Project Topics Centre to only provide guidance by which the projects should be pursued. We are neither encouraging any form of plagiarism nor are we advocating the use of the projects produced herein for cheating.

Terms and Condition


Using our service is LEGAL and IS NOT prohibited by any university/college policies You are allowed to use the original model papers you will receive in the following ways:
  • As a source for additional understanding of the subject
  • As a source for ideas for you own research (if properly referenced)
  • For PROPER paraphrasing ( see your university definition of plagiarism and acceptable paraphrase) Direct citing ( if referenced properly)
Thank you so much for your respect to the authors copyright