Pharmacy Management System

Identification This scheme is unquestionable to automate selective entropy for the judicature named Bete Zata Voluntary Counseling and exam in Awassa town. The system that is going to be developed is concerned with several(predicate) tasks. For example, it automates information on affected role ofs it records blood test result, records entropy on trainees etcetera It revolves some how uncomplainings get service and focusing. It also stores data like patient data, trainees data, prop championnt data, trainer data, etc. . 2 System overview. This System is developed with m any purposes. Out of its main purposes, it greatly minimizes cost, time and resources by computerizing the manual(a) system.. It will be possible to look to in a elemental way a specific patient pr trainee among many a(prenominal) patients or trainee in a simple way patients based on their ID. ID cast is unique to each patient and trainee 1. 3 General description Bete Zata is single of the non go vernmental organizations established in Ethiopia. This organization has three offices including the two branches in Naz areth and here in Awassa.The main goal of this organization is to treat human immunodeficiency virus/AIDS patients in a good manner, to minimize the transmission dictate of human immunodeficiency virus in Ethiopia by contri exactlying what it is possible. It gives VCT meaning voluntary direction and testing services. It also provides preparedness for many individuals. To generalize the main activities do by this organization, lets see the following paragraph. In the offset tone when the patient comes, he will be given a counseling service by the organizations direction about AIDS, its transmission, its present state, what he should do if he is supreme or else ostracise, shortly.Then he will discover to the examination room and the Doctor will construct blood from the patient and tests whether he is positive or negative. If the result shows he is positive, the patients health condition will be checked. Then he will be given diagnosis parallel to counseling if his health condition is not such good until he recovers from his poor condition. early(a) he directly goes to the counselor. The counselor will give detail advice for the patient. When the counselor finishes his advice, he will ask the patient wether he is voluntary to take training or not.If he is voluntary he will bring the training according to the time schedule of the training process. If the person is negative after the test, he will be referred to the counselor so that the counselor gives advice for the person so that he should protect himself from HIV. If he has the motive to insert in training he will be registered to the training. Besides counseling and testing patients, the organization also prepares training for different organizations and individuals. The flow map in the next pages describes the above activities of the organization. pic pic DESIGN Design is the first step to move from the problem domain towards the solution domain. Design is essentially the bridgework between requirement specification and the final solution for satisfying the requirements. It is the almost critical factor affecting the quality of the software. DATA FLOW DIAGRAMS It is one of the most important modeling tools practise by system analysts. It is wontd to illustrate how data flows in a system. DFDs use a number of symbols to represent systems. These symbols represent processes, data stores, data flows and external entities. 1. do Process show what systems do. Each process has one or more data inputs and produces one or more data outputs. Processes are represented by circles in a DFD. 2. Data Store A component of a DFD in which data is stored. 3. External Entity- These are outside the of the system but either supply input data into the system or use the system output. It is represented in a box. 4. Data flow It shows how data flows between process, data stores and external entities. They are represented by lines connecter system components. pic Level-0 Diagram pic ER ModelThis model describes the relationships between different activities. The entities include in the ER model are the following. ? exponent ? Patient ? line of business Test ? Trainer ? Trainee ? Training 1. 4 Objectives This project minimizes the complex and the tricky work of the manual processes, which is costly, in terms of time and resources. The general documentary of the software is to develop a system which is capable of automating all the manual works i. e. developing a database with ports for storing Specific goals. The specific goals of the final crop of the software are as follows. To computerize some of the manual activities of the organization To avoid the time for essaying the patients and trainees To make the organization well document To decrease the risk of losing the records 1. 5 Users This software is mainly used by the Record Office wor kers and concerned individuals like the counselors and trainers. 2. REFERENCED DOCUMENTS In doing this task, I have used the parcel Engineering book by PankaJ Jalotea, Software Engineering course handouts, System analysis and excogitate handouts and different information getting from the host organization around different tasks. 3. REQUIREMENTS 3. External interface requirement 1. User interfaces The system will have good looking, suck and neat interface so that substance abuser can interact comfortably to the software. To do this I will use buttons for any command to users, and I will not use any technical word for any command instead I will use command label that reflect the functions they perform. I will also use help statements in some of the windows to assist users in their activity. 2. Hardware interfaces the system does not indispensableness any special hardware to operate fully but recommended condition is 256 MB of RAM, 40 GB hard disk drive and nictate memory if po ssible. . Software interfaces the system will use only hardly a(prenominal) types of software. The main softwares that have detec tabular array influence on this system are Visual Basic (VB) and Ms Access. 2 Functional Requirements When we say operating(a) requirement, we mean the relationship between the input and output of the system. It describes all trading operations to be performed on the input data to obtain the output. This system has many inputs and outputs. Out of them the followings are some of them. Database Design A careful design of the database must proceed before storing the data in the database.This project contains about six database tables each containing their own primary profounds. Through these tables, a user can store his personal data. 1. Patient elaborate The VCT system receives patients information from the patient as an input and stores each individual information. The primary winder in this table is phone number. This table referred from simple eye Test table using date. So date is used as a exotic key. This patient detail table is related with Trainee table phone number. pic 2. melodic phrase Test percentage point This table uses the attribute date as a primary key. When you fill the date alue in the given space in the interface you will get the result as numbers (number of patients, HIV positives, HIV negatives). This table uses the date itself as a foreign key to be related with the Training table and Patient table. pic 3. advocator Detail Counselor detail stores information about the counselor. The primary key in this case is counselor ID. Through this key is the table relate with other tables. The table relates with the Trainee and Training tables. pic 4. Trainee Detail Information about trainees is stored in the Trainee table. In this case, the primary key is the Trainer ID.Through this ID the Trainee table is related with Training table. It is reference from the Trainer table using IDTrainer. pic 5. Training table All the data related with training is stored in this table. It uses two primary keys as the alike time. These are Place and Date. Training given at a ill-tempered place in a particular date is unique. But if we use these two fields separately, the uniqueness will be lost. pic 6. Trainer hold over Trainers information is stored here. IDTrainer is the primary key for the table. It is related with the Trainee and Training table by dint of this table. pic Form DesignAs I mention before the interface I am using is VB 6. 0. Using this software I design the following forms. In each form the buttons Insert, Update, Delete, Search and Exit buttons are used to add, modify, delete, get wind data from the data base and close the form. The symbols are to mean First, Previous, future(a) and Last respectively. 1. Login form pic 2. Main Form pic 3. Patient Detail pic Blood Test pic When you click the button Blood Test Detail bowl the Defined Date, you will get the number of negative and pos itive patients with in time intervals. 5. Counselor Detail pic 6. Trainee Detail pic 7. Training Detail pic When you click the button Status of Trainees, you will get the number of time-tested and non tested trainees. 8. Trainer Detail pic 9. Search form In this search button the user enters the corresponding IDs in the given space. For example, if we want to search the patient information, the user enters the ID of the patient and clicks search. The patient expand will display. pic issue Patient come Is he come for training? No Councelling trial run Is positive? Yes Is healthy? No Diagnosis Counseling Counseling Yes No Counseling Want training? No Yes A B C D Yes FLOW CHART Wait training sessionStart training instill others A B C Want training? Wait training session Start training Teach others End D Yes No Context Level DFD HIV VCT Counselor Patient Patient own(prenominal) Detail Test Result details Advice Patient details Trainee Trainee details Patient Service for patients Personal detail examen Testing bay Test detail Referring to counselor Current result Counselor Counselor details info Personal details Personal details Testing result Trainee Personal details Give advice Training for trainees Participating in training Referring for training Patient Advice Trainer May be Counselor Advice Patient Trains