Drug Procurement And Institution Tracking System

Project and Seminar Material for Computer Science and Computer Engineering

Drug Procurement And Institution Tracking System


Chapter One


Introduction

1.1 Background of Study

Computerization is defined as the control of processes by computers and its peripherals. Today it would be difficult to think of any process, business or action that could not have profited from the numerous benefits of the computer system. Controlling process or devices with computer started long ago since the invention of computer. In the 20th century inventors tried to make processes easier with the use of computers. Secondly computerization has been greatly applied or used in controlling process that requires frequent action such as drug procurement, drug management, drug tracking and drug distributions in hospital management information system in pharmacy departments of hospitals.

This project which is drug procurement and distribution tracking system provides a computer based information management system in a Pharmacy Department of the University of Nigerian Teaching Hospital (UNTH) Enugu by designing a cost effective, user friendly application, incorporating key attributes of data integrity and system security suitable for use in the pharmacy department of the hospital using Microsoft Access software in developing the database and visual basic as the programming language. The overall aim of this project is to optimize time and material in the processing of data needed for effective operation of large pharmacy department of a hospital. By this approach, data integrity, data redundancy, and consistency will be ensured.

Drugs are the chemical substances that are administered to patients for curative purposes and prophylaxis. It can also be known as a medicine, because it is the essential part of peoples care.

The ability of the computer to store and retrieve information at a very fast and efficient rate makes its application useful in management operations. Drug management involves drug procurement, drug distribution, drug tracking and its information management. Drug distribution is concerned with distribution of drugs within the different medical units or departments in a hospital, while drug procurement is concerned with the purchasing activities of the drugs by the pharmacy department of the hospital. In the same vein, drug tracking is concern with the continuous monitoring of the actual quantity of drugs held in the hospital pharmacy or any other drug warehouse /store. It also controls the stock level.

Pharmaceutical unit in a hospital is concerned with drug management activities. They carry out the responsibility of making appropriate selection and drugs used by formulating an annual, monthly, weekly or daily list of drugs requirement and management reports. However, in some hospitals today, some pharmacists still use the manual system of operation which can lead to inappropriate drug management errors due to problems of handling voluminous file within a short period of time. This could make data to be easily inaccessible and also delivery of drugs can lead to misplacement of patients’ files.


1.2 Statement of Problem

Drug procurement, tracking, distribution and information management in this regard are routine processes carried out in various hospitals across Nigeria. It is a common place to observe that these routine processes are still preformed manually or are minimally computerized even in our Teaching Hospitals. This manual approach to these routine operations has a lot of problems associated with it, ranging from poor handling of drug data of patients, lack of good storage information system for drugs and drug dispensary, delays, to the difficulty in retrieving information on drugs and patients’ records. In view of all these problems, it becomes necessary to develop a computer based drug information management system and distribution tracking system. This is what this research project is set to address by computerizing the routine processes in our hospitals and in particular that of Pharmacy Department of UNTH Enugu.


1.3 Objectives of the Study

The aim of this research project is to design and implement a computerized drug information management system, drug procurement and distribution tracking system. This includes:

  1. To order for drugs without mistake of procuring more than required.
  2. To take good stock of drugs.
  3. To prevent dispensary of expired drugs
  4. To ensure accurate keeping of records of drugs

1.4 Significance of the Study

The benefits derivable from this work include the following:

  1. It will provide reliable healthcare services.
  2. It will guarantee hospital management and patients of genuine and safe drugs.
  3. It will ensure an efficient and standard drug dispensary system.
  4. It will provide a data base for stock taking of drugs procured and dispensed any moment.

1.5 Scope of the Study

This research work will cover only the Pharmaceutical Department of the University of Nigerian Teaching Hospital (UNTH) Enugu. It will present an up to date and comprehensive design of the following:

Planning and control system which includes inventory control and drug distribution. Drug procurement procedure in a hospital. The expiry status of each drugs at any point in time

The Database of all kinds, types and names of some drugs that would be store and operate on.


1.6 Assumption

It is assumed that all the information gathered with the respect to inventory control is correct as implemented by the university of Nigerian teaching hospital (UNTH) Enugu.


1.7 Limitations of the Study

Time constraint; There is limited time go and meet the hospital pharmacist for proper information.
Due to the sensitive nature of organizational information, there was reluctance to release vital information which may jeopardize the security of the organization.


1.8 Project Report Organization

This research project covers almost all you need to know about drug procurement and distribution tracking system. Chapter one is the introduction and it covers the statement of problem, objectives of the study, significance of the study, scope of the study, assumption, limitations of the study and definition of terms. Chapter two is the literature review; it gives the detailed meaning of every associated word in my topic. Chapter three is the design and methodology; this involves the operation of the existing system and the method used. Chapter four is the system analysis and implementation; which talked about the operation of the proposed system. Chapter five is the summary, recommendation and conclusion.


1.9 Definition of Terms

Database;

A collection of logically related data to meet the information need of organization. DBMS; Database Management Software that enable the user to define, maintain Control the database. Application Program; A computer program that interacts with the database.

Menu;

This is a list of options presented on the screen with each option identified by short code followed by longer description of its purposes.

Drug;

It is referred to as a medicine or chemical substances that are administered to Patients for curative measures.

Pharmacy;

A placed in a hospital where medicine or chemical substances are kept, stored and prepared.

Flowchart;

A diagram that shows connection between the different stages of process of the system.

Primary Key;

The candidate key that is selected to identify the individual within the relation

Foreign Key;

An attribute or a set of attributes within one relation that matches the candidate key

Relation;

A relation is a named table with columns and rows

Attribute;

An attributes is a named column of a relation

Domain;

A set of allowable values for one or more table

Null;

It represents a value for an attribute that is currently unknown or not applicable

Database design;

The process of creating a design that will support emprise mission statement and mission required database e system.

Software:

These are program for computer which allows certain specific task to be accomplished e.g. word process etc.

Hardware:

Computer equipment used to perform input processing and system output activates.

Management information system:

Collection of people, database, and devices produced to use in providing routine information to manager and decision makers of the organization.


Chapter Five


Summary, Recommendation and Conclusion

5.1 Summary

These systems underpin all the activities of drug procurement and distribution tracking system, by providing good health care and safety. It also provides fast access to drug information and the current status of drug can be obtained from the database files unlike the manual system.

This can be applied by using computer to determine the effectiveness of drug stock control; it helps in making quick decision by members of the organization.

Further enhancement should be made on drug procurement, and distribution tracking system of hospitals such as medical records, billing and general hospital.


5.2 Limitation

  1. This work is design strictly for the use in UNTH. If any other hospital is to use it, it has to be modified.
  2. The hospital (UNTH) has to train their staff on the use of computer system.
  3. Some modification can be made in order to improve more on the design.

5.3 Recommendation

This work is recommended to improve in the way drug should be search. It should have a drop down menu that have lists of drugs in order to make work easy and also in the expiring date, it should have a sign to show that a drug have expired.


5.4 BEME (Bill of Engineering Measurement and Evaluation)

ITEM  ITEM PRICE( N )
COMPACT DISK500
MODEM5500
TRANSPORT5000
VB 10 TUTORIALS20,000
PHONE CALLS2,000
COMPUTER SYSTEM90,000
PRINTING2,000
BINDING500
TOTAL130,000

5.5 Conclusion

The benefit of using drug procurement and distribution tracking system cannot be over emphasized. This is because the system will increase the speed and accuracy of procurement, distribution and tracking of drug in pharmacy department of any hospital especially that of UNTH. It will also eliminate the case of misplacing files of patient and reduce the pilling up of papers in the office.


Drug Procurement And Institution Tracking System


Project Material Download

3,000 Naira


The complete material will be sent to you in just 2 steps.

Quick & Simple…


Step One Purchase

Make payment of ₦3,000: through USSD Transfer, Bank Mobile App, ATM Transfer, or POS Transfer to:

Access Bank PlcAccount No.: 0811003731
Name: Samphina Academy
Account Type: Current

Or Click Here to pay with Debit Card

FOR CLIENTS OUTSIDE NIGERIA:
Click Here to pay with Debit Card ($15)
GHANA – Make Payment of 60 GHS to MTN MoMo, 0553978005, Douglas Osabutey 

  PAY WITH CRYPTOCURRENCY


Step Two Purchase

Send the following details through Text Message or WhatsApp Messenger | +234-8143831497

  • Payment Details 
  • Email Address 
  • Drug Procurement And Institution Tracking System

The complete material will be sent to your email address after receiving your payment information | T & C Apply


  Contact Our Help Desk


You may also like:

⚠️ Need a different topic? Perform a quick search



Get A Complete Business Plan For Any Business In Nigeria

Business Plan for Businesses in Nigeria

  Business Plans in Nigeria


Drug Procurement And Institution Tracking System


Disclaimer

This research material “Drug Procurement And Institution Tracking System” is for research purposes and should be used as a guide in developing your research project / seminar work. For no reason should you copy word for word (verbatim) as samphina.com.ng will not be liable for any who copied the material.

The aim of providing this material is to reduce the stress of moving from one school library to another all in the name of searching for research materials. This service is legal because, all institutions permit their students to read previous projects, books, articles or papers while developing their own works. According to Austin Kleon “All creative work builds on what came before”.

samphina.com.ng is only providing this material “Drug Procurement And Institution Tracking System” as a reference for your research. The paper should be used as a guide or framework for your own paper. The contents of this paper should be able to help you in generating new ideas and thoughts for your own research. Use it as a guidance purpose only.


How to defend your research work


This is a general guide on how to defend your research work:

1. Prepare For Questions:

If you are preparing for questions that may be asked during your defense, then your answers will flow smoothly and effectively. This will prove your knowledge on the subject e.g “Drug Procurement And Institution Tracking System“, and strengthening your argument. Ask friends and family, read your work for them to listen to your presentation, and write down questions. You may be lucky the panel will ask you those you have already prepared on.

2. Strong Summary:

Summarizing your chapters will help keep your audience focused because it is easy for a mind to drift, so providing summaries will ensure your panel will follow along, even if they lose focus for a brief moment. Visual aides, such as graphs and power-point presentations can be very helpful. If you are going to use these, make sure you will practice your presentation with them.

3. Be Confident in Your Research Work:

Not knowing your topic “Drug Procurement And Institution Tracking System” inside out will cause you to struggle and ultimately fail with your defense. You need to know the subject from every angle to ensure you are fully prepared for any question that may come your way.

4. Conclusion:

Reinforce your findings to conclude your defense. The finale of your presentation should focus on proving the work that has been done. You may need to recap on what has changed and remained unchanged, if is necessary.

5 . Listen:

Before you get defensive or recite a particular answer, make sure you truly understand the question being asked. Being a good listener is an important quality, because providing an inaccurate or off-topic answer will also weaken the validity of your paper.

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.