Pharmacy Management System

Identification This system is developed to automate data for the organization named Bete Zata Voluntary Counseling and Testing in Awassa town. The system that is going to be developed is concerned with different tasks. For example, it automates data on patients; it records blood test result, records data on trainees etc. It revolves about how patients get service and counseling. It also stores data like patient data, trainees’ data, counselor data, trainer data, etc. . 2 System overview. This System is developed with many purposes. Out of its main purposes, it greatly minimizes cost, time and resources by computerizing the manual system.. It will be possible to search in a simple way a specific patient pr trainee among many patients or trainee in a simple way patients based on their ID. ID number is unique to each patient and trainee 1. 3 General description Bete Zata is one of the non governmental organizations established in Ethiopia. This organization has three offices including the two branches in Nazareth and here in Awassa.

The main goal of this organization is to treat HIV/AIDS patients in a good manner, to minimize the transmission rate of HIV in Ethiopia by contributing what it is possible. It gives VCT meaning voluntary counseling and testing services. It also provides training for many individuals. To generalize the main activities done by this organization, let’s see the following paragraph. In the first step when the patient comes, he will be given a counseling service by the organizations counselor about AIDS, its transmission, its present state, what he should do if he is positive 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 patient’s 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. 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 training or not.

If he is voluntary he will start 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 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 Design 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 quality of the software. DATA FLOW DIAGRAMS It is one of the most important modeling tools used by system analysts. It is used to illustrate how data flows in a system. DFD’s use a number of symbols to represent 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 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 joining system components. [pic] Level-0 Diagram [pic] ER Model

This model describes the relationships between different activities. The entities included in the ER model are the following. ? Counselor ? Patient ? Blood Test ? Trainer ? Trainee ? Training 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. developing a database with interfaces for storing Specific goals. The specific goals of the final product of the software are as follows. To computerize some of the manual activities of the organization – To avoid the time for searching the patients and trainees – To make the organization well documented – To decrease the risk of losing the records 1. 5 Users This software is mainly used by the Record Office workers and concerned individuals like the counselors and trainers. 2. REFERENCED DOCUMENTS In doing this task, I have used the “Software Engineering” book by PankaJ Jalotea, Software Engineering course handouts, System analysis and design 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, 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 technical word for any command instead I will use command names 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 need any special hardware to operate fully but recommended configuration 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 detectable 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 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 keys. Through these tables, a user can store his personal data. 1. Patient Detail The VCT system receives patients’ information from the patient as an input and stores each individual information. The primary key in this table is phone number. This table referred from Blood Test table using date. So date is used as a foreign key. This patient detail table is related with Trainee table phone number. [pic] 2. Blood Test Detail 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. 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. These 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 Design

As 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, 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 click 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 click the button “Status of Trainees”, you will get the number of 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 details 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 session

Start training Teach 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 Personal Detail Test Result details Advice Patient details Trainee Trainee details Patient Service for patients Personal detail Testing Testing request 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

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyStudyWriters
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Customer 452773, February 23rd, 2023
thank you so much
Customer 452749, June 10th, 2021
Business and administrative studies
Customer 452773, March 3rd, 2023
Business and administrative studies
excellent job!
Customer 452773, May 25th, 2023
Customer 452773, March 15th, 2024
excellent work
Customer 452773, October 6th, 2023
Business and administrative studies
Excellent job
Customer 452773, March 17th, 2023
ACC/543: Managerial Accounting & Legal Aspects Of Business
Customer 452773, January 10th, 2024
Social Work and Human Services
Although it took 2 revisions I am satisfied but I did receive it late because of that.
Customer 452603, March 25th, 2021
Business and administrative studies
excellent work
Customer 452773, March 12th, 2023
10th grade English
very good
Customer 452773, March 26th, 2023
Human Resources Management (HRM)
excellent job
Customer 452773, June 25th, 2023
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes
Live ChatWhatsApp