Design and Implementation of a Computer Intelligent Pharmaceutical Centre System

Abstract

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 the pharmaceutical establishments.

A drug procurement and distribution tracking system is a set of computer programs that obtain 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. The recording system tends to be complex and the method of tracking expired drugs is poor.

A good approach to this problem is to involve the use of computers by designing the form, using Access in developing the database and C# as the programming language, to enable keeping accurate records of drugs and prevent sales of expired drugs.

Table of Contents

Title page……………………………………………………………………i

Certification…………………………………………………………………ii

Dedication………………………………………………………………….iii

Acknowledgement…………………………………………………………iv

Abstract……………………………………………………………………v

Table of Content………………………………………………………….vi

CHAPTER ONE…………………………………………………………….1

INTRODUCTION

Background of study

Statement of problem…………………………………………………….2

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

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

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

Assumption……………………………………………………………….3

Limitations of the study………………………………………………….4

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

CHAPTERTWO…………………………………………………………..6

LITERATURE REVIEW ……………………………………………….6

Computerization in drug management system………………………….6

General overview of drug management information system……………6

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

Drug Distribution…………………………………………………………8

Softrex Formular………………………………………………………….8

Management Information System……………………………………….9

Benefits of Management Information System…………………………..9

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

CHAPTER THREE………………………………………………………12

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

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

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

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

Prototyping……………………………………………………………..13

Data collection………………………………………………………….14

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

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

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

The Pharmacy Department…………………………………………….15

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

Drug Procurement System in UNTH………………………………….16

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

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

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

CHAPTER FOUR………………………………………………………19

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

System design………………………………………………………….19

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

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

INTRODUCTION

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 provides a computer based information management system in a Pharmacy Department 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.

REFERENCE

Afolabi, M. (1991). Education and Training Archives in Africa. Odun Publishing              Company: Ibadan. Baho). l, R. (2004
Brian, T. (2006).  Implementing an Integrated Computer Patient Record. Department of Computer and Information Science. British Journal of Hematology: Linkoping University Sweden.
Chandrasekaran, J. (1983). Database Design and Management. (3rd ed.).Practice Hall Publishers: New York.
Codd, E. (1970). Approach to the Design of Medical Decision Making System. Macmillan Computer Publishing
Date, C. (2003). A Relational Model for Language Shared Banks. In Communication for Data Banks.
Enwere, J. (1992). An Introduction to Database System (5th ed.). Addison Wesley Publisher: London.
Essien, E. (1997). Records Management in Nigeria Library and Information Service Review. Akin Publishing Limited: Lagos.
George, W. Reynolds, & Ralph, M. (1998). Automated Drug Inventory Control System BSc. Project work. Federal University of Technology: Owerri.
Greg, P. (1998). Principles of Management Information System (3rd ed.). Jossey-Bass Publishers: UK.
John, S. & Roger, H. (1983). Teach yourself C# in 21 days. Macmillan Computer Publishing: London.

Join Our Newsletter!

Don’t miss this opportunity

Enter Your Details

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *