WEB BASED DRUG PROCUREMENT AND DISTRIBUTION TRACKING SYSTEM
ABSTRACT
Drug procurement and distribution tracking system is a set of computer programs that obtains the supplies of drugs, distribute the drugs and monitors the inventory control of the drugs. The aim of the study is to design and implement a drug procurement and distribution tracking system using pharmacy department of the Enugu State University Teaching Hospital (ESUTH) as a case study. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will provide information about the quantity of drugs remaining and ensure ordering of drugs without mistake of procuring more than required. The motivation that led to the implementation of the proposed system is as a result of the manual recording system which tends to be complex, difficulty in having access to drugs and patients records and the existing system lacks good storage information system for drugs (Database). The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. This research work will be of benefit to health care medical practitioners and pharmacists. The expected result is a computerized drug procurement and distribution tracking system that will prevent sales of expired drugs and ensure accurate keeping of records of drugs. Also, the system will generates an accurate drug items bill for payment purpose.
CHAPTER ONE
1.1 Introduction
Drug procurement and distribution tracking system is a set of computer programs that obtains the supplies of drugs, distribute the drugs and monitors the inventory control of the drugs. 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 and controls the stock level. Pharmaceutical unit in a hospital is concern with drug management activities. They carry out the responsibility of making appropriate selection and drugs uses by formulating an annual, monthly, weekly or daily list for drugs requirement and management reports. However, in some hospital today, some pharmacists still operates manual system of drug management information system which can lead into some drugs management errors like problems of handling voluminous file with a short period of time, which could make data not being easily accessed, late delivery of drugs and can also lead to misplacement of patients files.
As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.
1.2 Background of Study
Computerization according to oxford dictionary is defined as the control processes with the use of computers and its peripherals. Today it would be difficult to think of any process, business or action that could not be 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 process easier with the use of computers (Wikipedia, 2021). 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 department of hospital.
This project is to provide a computer based information management system in a pharmacy department of the Enugu State University Teaching Hospital (ESUTH) 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. The overall aim of this project is optimization of time and material in the processing of data needed for effective operation of large pharmacy department of a hospital. In doing this, data integrity must be compromise as consistency is ensured and data redundancy eliminated.
Drugs are the chemical substances that are administered to patients for curative purposes and prophylaxis. It can also be referrer as a medicine, because it is the essential part of peoples care.
The ability of the computer to store and to retrieve Information at every fast and efficient rate makes it application useful in management operations. The activity of drug management involves drug procurement, drug distribution, drug tracking and its information management. While drug distribution is concern with distribution of drugs within the different medical units or departments in a hospital, and drug procurement is concern with the purchasing activities of the drugs by the pharmacy department of the hospital. The challenges encountered that led to the execution of the research work is that, the ill often incurred from manual drug information management, drug procurement, drug tracking, and drug distribution procedures. It is clear that due to human limitations in the following up procedures, lapses are bound to occur.
1.3 Statement of Problem
Investigation revealed the problems of the existing system which is stated as follows;
- The manual recording system which tends to be complex
- Lack of good storage information system for drugs (Database)
- Difficulty in having access to drugs and patients records
- Lack of communication between the hospitals department as a result of non- computerized system of management.
In view of all these problems, it became necessary to develop a computer based drug information management system and distribution tracking system.
1.4 Aim and Objectives of the Study
The aim of the study is to design and implement a drug procurement and distribution tracking system. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:
- Provide information about the quantity of drugs remaining.
- Prevent sales of expired drugs
- Ensure accurate keeping of records of drugs
- Ensure ordering of drugs without mistake of procuring more than required.
1.5 Significance of Study
This research work lies in its usefulness as the people right to health care including the right to a reliable standard of health care services and assurance that drugs received are genuine and safe, hospital will rely on a standard drug management system for good management of drug. This also assures better welfare for patients.
In the face of rapid technology changes today, the need to develop computer model of drug based information management system arises .It will also lead to substantial improvement in welfare, profit margin and organizational effectiveness and efficiency.
This study will be of immense benefit to other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. This study contributes to knowledge and could serve as a guide for other study.
1.6 Scope of Study
The study focuses on the design and implementation of a drug procurement and distribution tracking system using pharmacy department of the Enugu State University Teaching Hospital (ESUTH) as a case study.
1.7 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
- Research material: availability of research material is a major setback to the scope of the study.
- Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
- Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).
1.8 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.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Web Based Drug Procurement and Distribution Tracking System can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Conceptual Review of Drug Information
- 2.2.1 Classification of Information Sources
- 2.2.2 Drug Reference Data
- 2.2.3 Drug Interaction
- 2.2.3.1 Drug Interaction Prevention
- 2.2.4 Drug Adverse Effect
- 2.3 Clinical Trials
- 2.4 Phases of Clinical Trials
- 2.5 Overview of Drug Management Information System
- 2.6 Theoretical Framework
- 2.6.1 Drug Procurement
- 2.6.2 Drug Distribution
- 2.6.3 Drug Contraindication
- 2.6.3.1 Types of Drug Contraindication
- 2.6.4 Drug Pharmacokinetics
- 2.6.5 Drug Pharmacology
- 2.7 Therapeutic Drug Monitoring
- 2.7.1 Drug Therapeutic Effect
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Web Based Drug Procurement and Distribution Tracking System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Conceptual Review of Drug Information
- 2.2.1 Classification of Information Sources
- 2.2.2 Drug Reference Data
- 2.2.3 Drug Interaction
- 2.2.3.1 Drug Interaction Prevention
- 2.2.4 Drug Adverse Effect
- 2.3 Clinical Trials
- 2.4 Phases of Clinical Trials
- 2.5 Overview of Drug Management Information System
- 2.6 Theoretical Framework
- 2.6.1 Drug Procurement
- 2.6.2 Drug Distribution
- 2.6.3 Drug Contraindication
- 2.6.3.1 Types of Drug Contraindication
- 2.6.4 Drug Pharmacokinetics
- 2.6.5 Drug Pharmacology
- 2.7 Therapeutic Drug Monitoring
- 2.7.1 Drug Therapeutic Effect
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Web Based Drug Procurement and Distribution Tracking System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Can the material for “Difficulties Encountered by Students in Solving Algebraic Problem in Senior Secondary School” be used as a guide for Education Project?
Yes it can be used — This research work examined the Difficulties Encountered by Students in Solving Algebraic Problems in Surulere Education District of Lagos State. The design used for the study was a descriptive survey for collecting data from a sample of one hundred and twenty students and fifteen mathematics teachers from four senior secondary schools selected. The instrument used was questionnaires for students, questionnaires for teachers and diagnostic test for the students on algebra. Chapter one of this work is introduction which deals with the background of the study, research questions, significance of the study, scope and limitation of the study, chapter two include the literature review of the previous researchers, the importance of mathematics and algebra, difficulties students encountered in solving algebraic problems, effect …
Is the topic “Proximate Analysis and in Vitro Antioxidant Activities of Watermelon Seeds” recommended for Biochemistry Project?
Yes it is highly recommended — Watermelon is a large berry whose swollen roundness and vibrant red flesh connote fertility and sexuality. Watermelon (Citrullus lanatus) is a flowering plant species of the Cucurbitaceae family. A scrambling and trailing vine-like plant, it was originally domesticated in Africa. It is a highly cultivated fruit worldwide, with more than 1,000 varieties. Watermelon is grown in favorable climates from tropical to temperate regions worldwide for its large edible fruit, which is a berry with a hard rind and no internal divisions, and is botanically called a pepo. The composition of a mineral can be expressed as a chemical formula, which simply gives the proportions of the different elements and groups of elements in the mineral. The study reveals the following …
Is the topic “The Importance of Improving Agricultural Production Through Co-Operative Societies” recommended for Agricultural Business Project?
Yes it is highly recommended — Agriculture is a science or practice of cultivating the land the keeping or breeding animal for food and for the promotion of the countries economy. The importance of improving Agricultural production through Co-operative Society especially in Anambra State, is their source of earning food and money for their survival, both man and animal around. It is also provision of raw materials for the Agro-based Industries, which helps in the production facilities programmes. Co-operative society is the coming together of different people in order to achieve a common goals and objectives of the society. They teamed up in Anambra State to cultivate and supply masses with food and also to feed themselves with their families. …
Can the material for “Effects of Synchronous and Asynchronous E-Learning Modes on Students’ Achievement and Skill Acquisition in Word Processing in Secondary Schools” be used as a guide for Education Project?
Yes it can be used — The study adopted a quasi − experimental research design. This study was carried out in Nsukka Local Government Area of Enugu State. The population for the study comprised 2,949 JSS1 students in 2015/2016 academic session from 16 secondary schools that offer computer studies in Nsukka Local Government of Enugu State. The study adopted multistage sampling technique. The sample size for this study was 70 JSS1 students from two purposively selected secondary schools using multistage purposive sampling techniques. Two sets of instruments were used for data collection − a 40 items multiple choices Word Processing Achievement Test (WPAT) and five items Word Processing Skill Acquisition Test (WPSAT). The instruments were subjected to face and content validation by three experts. The reliability of …
Can the material for “Design and Implementation of Mobile Application for Electronic Voting for SUG” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Electronic voting refers to the option of using electronic means to vote in referendums and elections. E-Voting is an election system that allows a voter to record his or her secure and secret ballot electronically. The inefficiency of voting process in Federal Polytechnic Nekede has resulted in a lot of problems. These problems have continued to obstruct the peace of democracy in Student Union Government (SUG) in Federal Polytechnic Nekede because the choice of a capable candidate is not encouraged by the current system. The aim of the study is to Design and Implement a Mobile Application for Electronic Voting for Student Union Government (SUG) using Federal Polytechnic Nekede as a case study. In achieving this aim, the following specific …
Can the material for “Impact of Credit Risk Management on Organization Performance” be used as a guide for Banking and Finance (BF) Project?
Yes it can be used — Credit Risk management is a systematic method of identifying, analyzing, assessing, rating, monitoring, controlling and communicating credit risks associated with any bank's activity, function or process to avoid or minimize losses and maximize opportunities. The aim of the study is to examine the Impact of Credit Risk Management on Organization Performance using Ibolo Micro Finance Bank Offa Kwara State as a Case Study. In achieving this aim, the following objectives were set out to examine the impact of credit risks on Organization Performance, examine the benefits of credit to Organization Performance, examine the relationship between credit risk and Organization Performance, and analyze the effect of credit risk management on the financial performance of Ibolo Micro Finance Bank. The research design …
Is the topic “Code-Mixing and Code-Switching in Nigerian Institutions: A Sociolinguistic Study” recommended for English Education Project?
Yes it is highly recommended — Code-switching is the use of more than one language, variety, or style by a speaker within an utterance or discourse, or between different interlocutors or situations. The study was carried out to Study the Socio-linguistic Effect of Code Switching and Code mixing in the Written English of Some Secondary School. In achieving this aim, the following specific objectives were laid out to conduct a sociolinguistic study on code-mixing and code-switching and examine ways can be used to avoid Code-Switching and Code-Mixing in learning English language. Investigation revealed that some of the studies focus on the way speakers of English code switch and mix between different language codes in their daily dialogues or conversations. All these studies drew their data from …
Can the material for “An Appraisal on the Significance of Incentives to Workers on Students Academic Performance in Secondary Schools” be used as a guide for Education Project?
Yes it can be used — Financial incentive is a process of guiding the conduct and influencing people so that they strives individual or group towards the achievement of group goals. The study was carried out to appraise the Significance of Incentives to Workers on Students Academic Performance in Secondary Schools. In achieving this aim, the following specific objectives were laid out to determine the correlation between financial incentives for workers and productivity in the area under study, evaluate the weaknesses to overcome and enhance the motivation and productivity and find out whether or not financial incentives are the highest/greatest motivators to workers on Students Academic Performance in Secondary Schools. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information …
Can the material for “Fuel Subsidy Removal and National Development in Nigeria: 1999 – 2012” be used as a guide for Political Science Project?
Yes it can be used — Fuel subsidy is critical to the Nigerian economy. It is argued that fuel subsidy for years has remained the only avenue through which the Nigerian government lived up to its socioeconomic responsibility to its citizenry; and the attempt to withdraw this policy has been interpreted as a move by the government to default on its responsibility. This study, therefore, investigates the effects of fuel subsidy removal on national development in Nigeria between 1999 and 2012. The specific questions for investigation were: Does the incremental increases in the pump price of fuel undermine the living standard of Nigerians? Has the fuel subsidy probe improved on national revenue accounting? Did the mass protests that accompanied fuel price increase undermine the economic stability …
Can the material for “An Assessment of Conflict Management in an Organization” be used as a guide for Human Resource Management (HRM) Project?
Yes it can be used — This research work aimed at investigating the assessment of managing conflict in organization especially that of non-profit making organization. The objective of the study is to provide necessary strategies to manage conflict and to make appropriate recommendation, for effective conflict resolution, and to ensure development, productivity and societal growth. Our study shows that Conflict stems from incompatibility of goals and interest and if it continued it will destroy the Organization. Conflict affects the Organization in several ways such as decreased employee satisfaction, insubordination, decreased productivity, economic loss, fragmentation, and poor performance. A formal questionnaire was constructed and survey method was used to collect data from a target group of respondents. Descriptive analytical techniques such as frequency, percentage, mean, standard deviation …