Contents

ACKNOWLEDGEMENT

I humbly express my gratitude towards my teachers and my class mates, who with their highest efforts and guidance have helped me all the way through this project. At the time, I hope that my project can help a lot in solving problems, as I have put in the best of my abilities in making this project. This project can solve a high problem of old and bulky registers it provides convenience to the users.

SUMMARY

The objective of this project is to present guidelines that can be used during the acquisition, development and maintenance of database systems. Good practices for the design, operation, and maintenance of the database are presented in the second part of the segment.

This project proposes different architectures for database systems. The centralized, distributed, parallel, and designs are presented each with its strengths and weaknesses and the concrete reasons for their selection. The project recommends using centralized databases unless there is a need for else.

Good practices for data modeling, schema representation, using MS tools, data fields naming conventions, using database triggers, and primary key selection are presented for a good design of the database system.

In a later section, this project presents good practices for the operation and maintenance of the database systems, practices for data access and security, data storage and space allocation as well as for tuning the database, auditing the database, and training on its use.

The project proposes a schema for dividing the roles and responsibilities for operating and maintaining the database system among the staff concerned.

CHAPTER NO. 1

INTRODUCTION

Introduction

Now a day’s Information and communication technology (ICT) plays a great role in different fields or areas among thus Health care system belongs to this. This leads to various studies and researches being conducted to selected health care facilities. It is necessary to ensure a technologically appropriate, equitable, affordable, efficient, and environmentally adaptable and consumer friendly system, designed to fully utilize the ICT for the maximum benefit in the health care industry.

Here computers have great relevant on storing data’s securely and ease access on them in short period of time.

To exploit the ICT in health care system, Pharmacy management system is being build. Pharmacy management system is robust, integrated technology. Pharmacy management system deals with the maintenance of drugs and consumables in the pharmacy unit. The set-up of this pharmacy management system will ensure availability of sufficient quantity of drugs and consumable materials for the patient. This will enhance the efficiency of clinical work and ease patient’s convenience, bearing in mind that in Ethiopia is heading towards pharmaceutical care of patients. In addition, Pharmacy management system will be able to process drug prescription with ease. PMS (Pharmacy Management System) will design to detect drug interaction.

In general, The Pharmacy management system is based on computer technology that gives service for users, managed by the pharmacist who give implementation of function relatively in effective times as well as will design for removing time wasting, saving resources, easy data access of the medicine, security on data input and data access by removing almost manual based system.

Purpose

The pharmacy management system is built for the sake of ensuring effective and clear data saving and manipulating as well as neat work on the pharmacy medical products. This refers the pharmacy management system project highly minimize time and resource by which, searching the medicine data you can get the data in quickest time. And almost the resources are wise used since most actions are done on the pharmacy system. Some of the resources minimized include paper, manpower and related things. The other thing is for storing data’s in secure way.

A summarized list of drugs dispensed to patient can be viewed for monitoring purposes. Also, PMS will be able to generate report on the list of drugs dispensed in the polyclinic for a given time. And there is a message alert for the user if the stock holding quantity reaches a low level. Thus, the pharmacist will need to replenish the drugs.

Objectives

It is the user-friendly application for Pharmacist which reduces the burden and helps to manage all sections of Pharmacy like Medicine management and Billing etc., which improve the processing efficiency. It deals with the automating tasks of maintaining of Bills. In Pharmacy, Billing management is the key process. Including safe data store about medicine as well as fast searching, delete and update of medicines. The pharmacy management system is easy for use so the user can do pharmacy actions without ambiguities.

The main Objectives of the PMS is making the pharmacy organizations computerized by creating neat work through minimizing or eliminating wasting of time as well as removing the resources such as papers for data saving since know a day is paper based, decrease malfunctioned works on the medical usage by giving correct information on each medicine.

Overview

The pharmacy management system is built to replace manual based system to computerize. Here system is expected to be efficient, useful and affordable on implementing tasks that is order by the pharmacy manager.

CHAPTER NO. 2

SYSTEM ANALYSIS

Current System

The current Pharmacy system were manually base system which is almost all works on the pharmacy organization is accomplished by papers. Among thus Medicine data search to buy, and other related works. And the other one is data security, the data’s can be accessed anyone who entered to the pharmacy house as friends, other Humans without the volunteer of the pharmacist.

The pharmacists work in tedious situation because of the upper reasons. Not efficient on arrange medicine on the shelf meaning arrangement method is difficult to take in mind.

In current system almost, all pharmacies do not use computerized system but use computer for giving bills only for the sold medicine to the user. And use manual searching of medicine on shelf because of manual based system and there is nothing which gives alarm for the finished or sold medicine.

Also, there is a difficulty on store the data which wastes resources as well as time to retrieve the necessary data from the manually based data system. So generally, the current system does not arrange medicine in systematic way, does not store the medicine appropriate data, security for the data is low, does not indicate how much medicine is needed and sold quickly and efficiently.

The pharmacy system will implement by the pharmacy unit of the organization. At present, manual system is being utilized. This system requires the pharmacist to manually monitor each drug that is available in the pharmacy shelf. This involves manually entry up on arrival of batches of drugs and upon drugs’ movement out of the unit, for example, dispensing to patients or product recall or loan to other clinics/hospitals. Upon a certain period, such as month, the pharmacist is required to generate reports on the movement of drugs. This is to monitor the justification of ordering to replenish the already diminishing stocks. In addition, ordering of drugs is also being done manually. Significant amount of time is allocated for writing order as one needs to go through the stocks’ balance and rough estimate of the amount to order. This usually led to mistakes as one May over or under-order. Thus, in this aspect, the workload of a pharmacist increases. As a result, sometimes, patient care, in terms of counseling, is compromised due to time constraints.

Drawbacks

Labor-Intensive

A disadvantage of manual inventory systems is that they can be highly labor-intensive to operate. They require continuous monitoring to ensure that each transaction is accounted for and that products are maintained at the appropriate stocking levels. It is also more difficult to share inventory information throughout because the lack of computerization makes accessing inventory records a more troublesome process. The time spent monitoring inventory levels could be used on more productive activities.

Human Error

A manual inventory system relies heavily on the actions of people, which increases the possibility of human error. People might forget to record a transaction or simply miscount the number of goods. This results in needless additional orders that increase the inventory carrying costs and use up precious storage space. Inaccurate physical counts could also result in not ordering enough of a product, meaning the pharmacy could run out of a crucial item at the wrong time.

Lack of security

Another obvious disadvantage is the likelihood of damage to the records themselves. It might seem an obvious downside, but the records in a paper based accounts system are susceptible to damage by water and fire etc.

Quality

Quality of output is less consistent and often not well-designed. At worst, hand written records may be illegible and so completely useless. Poorly presented information may fail to communicate key points.

Alterations:

It is difficult to make corrections. If a manual document contains errors or need updating it is often necessary to recreate the whole documents from scratch, rather than just a new version with the relevant details changed.

Less accessible:

Information is generally less accessible. Access to information is often restricted to one user at a time, paper files can easily be misled or buried in trays, in which case the information they contain is not available at all.

CHAPTER NO. 3

PROPSED SYSTEM

The pharmacy management system is design based on computer science students to illuminate the problem of the current system which provided by the system involved all the pharmaceutical employees of the pharmacy. This accessibility of the information will be great advantage as it reduced further medical errors associated with physicians and nurses.

The system handles all aspects of the inventory control function. It allows the pharmacist to receive new batches of drugs, delete obsolete drugs and modify the current dosage and identification of drug in the database. Furthermore, the system eases the process of stock replenishment.

On the other hand, PMS enables dispensation process. It stores all the physicians’ prescription of the patients. A summarized list of drugs dispensed to the patient can be viewed for monitoring purposes.

With the proposed system, the pharmacist will be able to monitor the movement of the drugs with ease. The system is designing to track the entry of refresh batches of drugs, be it upon orders from manufacture or loan from the hospital/clinics. It also monitors the drug’s movement history, thus leads to better inventory management of money allocated for the purchase of drugs.

Compared to the current manual system, the implementation of Pharmacy management system will have reduced the time spent for paperwork, leading to concentration on improving pharmaceutical care of patients, especially emphasis on patients’ counseling and patient medication monitoring. It will be greatly embraced by the pharmacy profession as it is one giant leap towards pharmaceutical care of patients.

Overview

The pharmacy management system provides functions on identify medication usages instruction, minimize human errors in medication safety, facilitate accessibility of drugs’ information and information management among employees, providing optimal drugs movement in pharmacy unit, enable reports with in significantly short period of time, despite simultaneous usage of database for the purpose stated above.

The system will solve the problem of the current system by minimizing time wastage and reduce resources which simply change manual based system to computerized system.

Advantages

There are many advantages in a computerized system such as: store the necessary information of drugs, prepare bill for the medicine, give week reports, easily searching of medicine, working in two languages, Update, delete and save data of medicine.

Generate report:

The pharmacy management system generates report weakly on information about the drugs and it exports the information as output document.

Store the necessary information of the drugs:

The PS (pharmacy system) stores the detail information about each medicine including Actual name, formula of medicine and how it is importance and for which diseases is required. Since the information for each drug were required in some cases like the use of drugs, when use drugs and for whom is given.

Searching Medicine and other Data’s:

The PS has easily searching of medicine which shows in which shelf is put and the behavior of the medicine. The searching process is based on the name of the give data or the identification of the item. Here when the user searches the item on search bar the related things were displayed in the screen and can select the actual item that the user needs.

Alerting pharmacy Data’s in the system:

Changing medicines to another because of medicine outdated, modifying the saved medicine data for incorrect data, deleting of data of the pharmacy can be done on the system.

Support multi languages:

The system supposed work on primarily in English and Arabic. So, the user can use one of these languages. the purpose of the languages was when the user is unfamiliar for the system he/she may change the language that he/she understood, simply it serves as a translator.

The function what the system do is:

ü Store Medicine ‘s data.

ü Search Medicine data effectively.

ü Update, delete, and Edit medicine information.

ü Generate report on medicine.

ü Prepare bill for the medicine.

ü Gives navigation or information for pharmacy organization.

ü Give alert for the user when medicine item is low.

ü Changing login password.

ü Have the system document how to use the system.

This pharmacy management system can operate in the following characteristics.

Usability:

Anyone familiar with windows can operate the system since it has user friendly user interface. Which have the instruction menu’s how to use it which self-directive application then can be used the system without ambiguity.

Reliability:

The pharmacy system is available based on the user needs, can work properly, and do transactions efficiently including safe data management of the pharmacy. For invalid and malfunctioned operation, the system will restart to prevent data loose as well as safe operation within 5 seconds. The pharmacy system is password protected to change things on the system. Here the pharmacist manager control over the system by login to the pharmacy system. Any user can’t use the system but the guest user can see on general properties of the pharmacy and medicines without password. As result data is protected and controlled by only the administrator.

Performance:

The pharmacy management system operates its function in small amount of time which is less than two seconds and can be accessed by one user at a time or concurrently. The user must first login to the system.

User interface:

The user interface is friendly which is easy to use. And having attractive frame structure which is prepared in assumption with other related systems. Also, the user can change him/her user favorite interfaces that Is available in the system.