Design And Implementation Of A Computer Intelligent Pharmaceutical Center System (A Case Study Of Unth Enugu)

Design And Implementation Of A Computer Intelligent Pharmaceutical Center System (A Case Study Of Unth Enugu)

Abstract of Design And Implementation Of A Computer Intelligent Pharmaceutical Center System

The need to develop a system that would improve the management of stocked pharmaceutical items in the pharmacy became beatable due to some setbacks experienced by the current operations of pharmaceutical establishment. 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. Using the pharmaceutical department of UNTH University teaching hospital as a case study, the department using manual method to operate lacks good storage of information system for drugs. Recording system tends to be complex and the method of tracking expired drug is poor. The good approach to this problem is to involve the use of computer by designing the form, using Access in developing the database and C# as the programming language, to enable keeping accurate record of drug and prevent sales of expired drug. This guarantees the people’s right to good health care and ensures that drugs received are genuine and safe.

Table of contents on Design And Implementation Of A Computer Intelligent Pharmaceutical Center System

Title page………………………………………………………………

Certification………………………………………………………………

Dedication…………………………………………………………………

Acknowledgement……………………………………………………

Abstract………………………………………………………………

Table of Content…………………………………………………………

CHAPTER ONE……………………………………………………………

INTRODUCTION

Background of study

Statement of problem……………………………………………………

Objectives of the study………………………………………………

Significance of the study……………………………………………

Scope of the study…………………………………………………………………

Assumption………………………………………………………………

Limitations of the study………………………………………………

Definition of Terms…………………………………………………

CHAPTER TWO…………………………………………………………

LITERATURE REVIEW ……………………………………………

Computerization in drug management system………………………

General overview of drug management information system………

Drug Procurement……………………………………………………….

Drug Distribution………………………………………………………

Softrex Formular…………………………………………………………

Management Information System………………………………………

Benefits of Management Information System…………………………

Component of a Database Management System……………………

CHAPTER THREE………………………………………………………

Description and Analysis of the Existing SYSTEM………………

General analysis of the existing system……………………………….

structured system analysis and design methodology (ssadm)………….

Expert System………………………………………………………….

Prototyping…………………………………………………………….

Data collection…………………………………………………………

The Primary Collection………………………………………………

The Secondary Collection……………………………………………

Analysis of Existing System and Design……………………………

The Pharmacy Department……………………………………………

UNTH Inpatient Drug Management………………………………….

Drug Procurement System in UNTH…………………………………

The Patient Medication Sheet and Treatment………………………

Present System Approach to Drug Management…………………….

Limitations of the Existing System…………………………………

CHAPTER FOUR……………………………………………………

Design of the New System…………………………………………

System design…………………………………………………………

Expectations of the new system……………………………………

Design of the new system

File Specification

File Operation

Administrator

The Registration Form Drug Statistics and Stock Balancing

Program Assets

Database File

System Flowchart

Top down diagram

Implementation, testing, and packaging

Choice of Development Tools

System Requirements

Software Requirements

Hardware Requirements

Implementation

Testing

CHAPTER FIVE

SUMMARY, RECOMMENDATION AND CONCLUSION

Summary

Recommendation

Conclusion

chapter one of Design And Implementation Of A Computer Intelligent Pharmaceutical Center System

INTRODUCTION

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 C# 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.

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.

OBJECTIVES OF THE STUDY

The aim of this research project is to develop a system that will do the followings:

• Order for drugs without mistake of procuring more than required.
• Take good stock of drugs.
• Prevent dispensary of expired drugs.
• Ensure accurate keeping of records of drugs

 

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

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:

1. Planning and control system which includes inventory control and drug distribution
2. Drug procurement procedure in a hospital.
3. The expiry status of each drugs at any point in time
4. The Database of all kinds, types and names of some drugs that would be store and operate on.

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.

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.

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.

GET COMPLETE WORK

See more computer science project topics here

GET THE COMPLETE PROJECT»

Do you need help? Talk to us right now: (+234) 08060082010, 08107932631 (Call/WhatsApp). Email: [email protected].

IF YOU CAN'T FIND YOUR TOPIC, CLICK HERE TO HIRE A WRITER»

Disclaimer: This PDF Material Content is Developed by the copyright owner to Serve as a RESEARCH GUIDE for Students to Conduct Academic Research.

You are allowed to use the original PDF Research Material Guide you will receive in the following ways:

1. As a source for additional understanding of the project topic.

2. As a source for ideas for you own academic research work (if properly referenced).

3. For PROPER paraphrasing ( see your school definition of plagiarism and acceptable paraphrase).

4. Direct citing ( if referenced properly).

Thank you so much for your respect for the authors copyright.

Do you need help? Talk to us right now: (+234) 08060082010, 08107932631 (Call/WhatsApp). Email: [email protected].