Pharmacy Management System

acknowledgement This arrangement is developed to automate data for the boldness named Bete Zata Voluntary focus and Testing in Awassa town. The agreement that is going to be developed is concerned with different tasks. For example, it automates data on patients it records stock certificate test result, records data on trainees etc. It revolves about how patients get service and counseling. It also stores data equivalent patient data, trainees data, counselor-at-law data, trainer data, etc. . 2 System overview. This System is developed with many purposes. Out of its main purposes, it greatly calumniates cost, time and resources by computerizing the manual schema.. It forget be possible to hunting in a straightforward way a specific patient pr trainee among many patients or trainee in a dewy-eyed way patients based on their ID. ID subprogram is unique to each patient and trainee 1. 3 General explanation Bete Zata is one of the non governmental brasss established in E thiopia. 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 bang-up manner, to minimize the transmission rate of HIV in Ethiopia by contributing what it is possible. It gives VCT reputeing voluntary counseling and exam services. It also provides planning for many individuals. To cosmopolitanize the main activities done by this organization, lets put through the following paragraph. In the first step when the patient comes, he will be wedded a counseling service by the organizations counselor about AIDS, its transmission, its present state, what he should do if he is affirmatory or else negative, shortly.Then he will refer to the examination room and the Doctor will take blood from the patient and tests whether he is positive or negative. If the result shows he is positive, the patients wellness condition will be checked. Then he will be given diagnosis correspond to counseling if his health condition is not such good until he recovers from his poor condition. Otherwise 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 reproduction or not.If he is voluntary he will father 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 agent to participate 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 chart in the next pages describes the above activities of the organization. pic pic DESIGN material body is the first step to move from the problem domain towards the solution domain. Design is essentially the bridge between requirement specification and the final solution for satisfying the requirements. It is the most critical factor affecting the whole step of the software. DATA point DIAGRAMS It is one of the most important modeling tools employ by arrangement analysts. It is used to illustrate how data flows in a system. DFDs use a number of symbols to mean systems. These symbols represent processes, data stores, data flows and external entities. 1.Process Process show what systems do. Each process has one or more than 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 international 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. T hey are represented by lines joining system components. pic Level-0 Diagram pic ER ModelThis model describes the descents between different activities. The entities include in the ER model are the following. ? Counselor ? Patient ? Blood Test ? Trainer ? Trainee ? procreation 1. 4 Objectives This project minimizes the complex and the difficult work of the manual processes, which is costly, in terms of time and resources. The general objective of the software is to develop a system which is capable of automating all the manual works i. e. development a database with interfaces for storing Specific goals. The specific goals of the final product of the software are as follows. To computerize nearly of the manual activities of the organization To avoid the time for searching the patients and trainees To make the organization well documented To moderate the risk of losing the records 1. 5 Users This software is mainly used by the Record Office workers and concerned individuals li ke the counselors and trainers. 2. REFERENCED DOCUMENTS In doing this task, I have used the computer software Engineering book by PankaJ Jalotea, Software Engineering course handouts, System analysis and design handouts and different randomness getting from the host organization around different tasks. 3. REQUIREMENTS 3. External interface requirement 1. User interfaces The system will have good looking, clear and neat interface so that user can interact easily to the software. To do this I will use buttons for any command to users, and I will not use any practiced word for any command instead I will use command names that theorise the functions they perform. I will also use help statements in some of the windows to assist users in their activity. 2. ironware interfaces the system does not need any special hardware to operate fully but recommended form is 256 MB of RAM, 40 GB hard disk drive and flash memory if possible. . Software interfaces the system will use only few types of software. The main softwares that have detec parry influence on this system are Visual Basic (VB) and Ms Access. 2 Functional Requirements When we say functional requirement, we mean the relationship between the input and output of the system. It describes all operations to be performed on the input data to view as 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(prenominal) proceed before storing the data in the database.This project contains about six database tables each containing their own autochthonic keys. Through these tables, a user can store his personal data. 1. Patient power point The VCT system receives patients information from the patient as an input and stores each individual information. The primary key in this table is forebode number. This table referred from Blood Test table using date. So date is used as a foreign key. This patient detail table is cog itate with Trainee table phone number. pic 2. Blood Test period 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 instruction table and Patient table. pic 3. Counselor 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 referenced 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 same time. The se are Place and Date. Training given at a particular place in a particular date is unique. But if we use these two fields separately, the uniqueness will be lost. pic 6. Trainer Table Trainers information is stored here. IDTrainer is the primary key for the table. It is related with the Trainee and Training table through 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, attend and Exit buttons are used to add, modify, delete, find data from the data base and close the form. The symbols are to mean First, Previous, Next and Last respectively. 1. Login form pic 2. Main Form pic 3. Patient Detail pic Blood Test pic When you poky the button Blood Test Detail till the Defined Date, you will get the number of negative and positive patients with in time intervals. 5. Counselor Detail pic 6. Trainee Detail pic 7. Training Detail pic When you prattle the b utton Status of Trainees, you will get the number of tested and non tested trainees. 8. Trainer Detail pic 9. face 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 expatiate will display. pic Start Patient come Is he come for training? No Councelling Examination 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 Teach others A B C Want training? Wait training session Start training Teach others End D Yes No consideration Level DFD HIV VCT Counselor Patient Patient personalized Detail Test Result details Advice Patient details Trainee Trainee details Patient Service for patients Personal detail Testing Testing bay Test detail Referring to counselor Current result Counselor Counselor details info Personal de tails Personal details Testing result Trainee Personal details Give advice Training for trainees dynamic in training Referring for training Patient Advice Trainer May be Counselor Advice Patient Trains