Addis Ababa University Faculty of Medicine established in 1964 with the goal of producing medical doctors to handle the country’s health problems. Starting from 1979 the faculty launched graduate programs, which was the first graduate program in the history of AAU. In 1998 Tikur Anbessa Hospital, which is the largest referral hospital in the country was given to Addis Ababa University (AAU) from the Ministry of Health (MoH) for the faculty as a main teaching hospital. The faculty is the oldest and the largest among the health training institutions in the country, staffed with the most senior specialists. The Hospital provides different services along with the training activities. Drug dispensing is one of the activities performed among other activities provided by the hospital. Information Technology has revolutionized the life of human beings’ and has made the lives easier by the various kinds of applications in different institutions including Hospitals and other service providing organizations. In the light of the rapid changes with the use of Information Technology, there are many tools, technologies and systems have been produced and invented. In the modern world, time is short so if there are many processes taken place at same time within a place there is a need for integration of all the processes, creation of paperless environment also ensures efficient task management. Nowadays all the businesses are shifting to computer based system. The purpose to having a computer based system is to help to increase the market share and easiness for users to use. It is increasing the demand among the user. Therefore, this project is concerned with developing a Drug Inventory Management System for Black Lion Hospital Pharmacy. In this system the drug management becomes more efficient & easier to handle with its reliable system components.
Overview of the existing system
Black Lion hospital has different that perform different health services. The pharmacy department is responsible for the preparation of drug inventory reports. The steps undertaken and the procedures followed to prepare drug inventory reports are described below: * The drug dispensing section receives prescription from the patient which contains the name of the drug and other data; check whether the drug/s is/are available or not in the respective pharmacy and give feedback to patients accordingly. If the drug s is available, the dispenser passes order for payment. * The Casher provide bill for the patient upon payment and send payment reports to the dispensing section. * Based on the payment reports received, the dispensing section provide drug to the respective patient and deduct the sold drug from the stock to adjust the balance. Besides the dispensing section, send report to different sections of the pharmacy. * All these drug inventory processing activities and report generation are handled using the Microsoft Excel application software. 2.2. Purpose of the System
The new system will eliminate the problems with regards to processing, maintaining and accessing information needed by the Black Lion pharmacists, dispensers, patients and managers. The new system is expected to provide an efficient and easy way of processing drug inventory activities. The new system will be implemented as a web based application with simple and easy- to-use interfaces for processing drug inventory system for Black Lion Hospital Pharmacy. All information relevant to the activities of dispensing clerks will be recorded electronically in a database in a way that will facilitate fast information retrieval, update, and proper data management, and easy information distribution. User interfaces that help in querying information from the database easily will be provided. The proposed system will have a database of drug data and a front-end application that accesses the database. All input data from...