DESIGN AND IMPLEMENTATION OF A COMPUTERIZED PHARMACY MANAGEMENT SYSTEM CASE STUDY OF JAHEL PHARMACEUTICALS LTD, ENUGU

0
990

ABSTRACT

            This project is written to help Pharmaceuticals Companies especially Jahel Pharmaceuticals ltd Enugu in the areas they encounter problems in keeping their record and the solution given to tackle those problem.

            The research was carried out of many difficulties such as time factors, money and inability to get much information that could have been of help. But still with all those the researcher came up with something readable and valuable to any body that goes through it.

TABLE OF CONTENT

Title page                                                                                                         i

Certification                                                                                                     ii

Dedication                                                                                                       iii

Acknowledgement                                                                                           iv

Abstract                                                                                                           v

Table of contents                                                                                             vii

CHAPTER ONE

INTRODUCTION                                                                                            1

1.1       Background of the study                                                                     1         

1.2       State of the problem                                                                2

1.3       Purpose of the study                                                                3

1.4       Aims and objectives                                                                3

1.5       Scope of study                                                                         5

1.6       Limitations of study                                                                 5

1.7       Assumptions                                                                            6

1.8       Definition of terms                                                                              7

CHAPTER TWO

LITERATURE REVIEW                                                                      8

CHAPTER THREE

  • Description and analysis of existing system                             15
    • Fact finding method used                                                                    17
    • Organization structure                                                              19
    • Objectives of Existing system                                                  21
    • Input, Process and Output Analysis                                         22
    • Information Flow Diagrams                                                     26
    • Problems of the Existing System                                              27
    • Justification of the New System                                                          28

CHAPTER FOUR

  • Design of the New System                                                       30
    • Input Specification and design                                                 30
    • Output specification and design                                                           32
    • File Design                                                                                           34
    • Procedure chart                                                                                    36
    • System flow chart                                                                                38
    • System requirements                                                                40       

CHAPTER FIVE

  • Implementation                                                                                    42
    • Program Design                                                                                   45
    • Program Flowchart                                                                   48
    • Pseudo code                                                                                        54
    • Source Program: Test Run                                                       59

CHAPTER SIX         

Documentation                                                                                                60

CHAPTER SEVEN

  • Recommendation                                                                                 62
    • Conclusion                                                                                          64

Bibliography  

CHAPTER ONE

INTRODUCTION

The role information technology have played in various field of human endeavors can not be over emphasized. As most section of humanity like banking industries, auto mobile industries etc have experience the influenced of information technology like wise in pharmaceutical industries.

Usage of Information Technology (IT) remained comparatively very less in Health sector than other sectors despite having more potential. Health Institutions, which is important sector, should encourage IT usage resulting better productivity, effectiveness, efficiency and economics leading to better health care to all. This paper tells a success story of implementation of ICT in monitoring of medicine in health Institutions such as Jahel Pharmaceutical LTD implemented by National Informatics Centre, Enugu State Centre for Directorate of Health Services, Enugu. System works on low-end resources and E-mail based data transfer from District Hard Quarter to State Head Quarter. Implementation of Med-Centre in all the districts of Enugu results in check on pilferage of medicine, increase in availability of medicine at Government Institution, increase in attendance of patient/doctors in health institution, optimal utilization of medicine and data capturing at source, resulting in availability of error-free data at State Head quarter

The present invention relates to a product monitoring system for
monitoring, or keeping track of, various types of products. The invention is particularly useful in merchandising of products and also in inventory control of products, and is therefore described below particularly with respect to such applications.
In the common retail store, consumers remove products from the shelves, place them in their shopping carts, and present them at a point of sale (POS) for identification, price calculation and payment. To identify each purchased product, the products are usually labeled with a universal product code (UPC, or “bar-code”) readable by a scanner connected to the POS. Scanning is done by a cashier holding each product to expose its UPC to the scanner. The labor cost and the line waiting time in such systems have prompted the introduction of a commercial self-scanning system, wherein the shopper uses a handheld scanner to scan the UPC of each item placed in his shopping cart. The handheld scanner includes a display, a  copy of the updated price database, and a calculating unit, enabling the shopper to update the information regarding the cart’s contents. Items whose UPC cannot be read by the scanner (which is quite common) are presented at the POS for re-scanning. Random re-scanning of the entire cart contents deter shoppers from dishonest behavior.

Also known are electronic shelf label systems, in which the store’s central computer downloads price information to electronic shelf labels placed near merchandise items.
Also known are systems for counting items displayed on the shelves, as part of routine inventory control or order management, in which a handheld portable unit is used to either scan or key-in the product’s code and then key-in count information. Such information is downloaded later into the store computer through a terminal at the store office.

BACKGROUND OF THE STUDY

Pharmaceutical Industry, that section of industry which manufactures medicinal chemicals and prepares them for use in the prevention or treatment of disease. Some companies engaged in this business manufacture pharmaceutical chemicals in bulk (primary manufacture), but all of them prepare them for medical use by methods known collectively as secondary manufacture. These highly automated processes include the production of drugs in single-dose forms, such as tablets, capsules, or sachets for oral administration, solutions for injection, and pessaries and suppositories for insertion into the vagina or rectum respectively.

Immunization: An enormous part of the pharmaceutical industry’s output consists of vaccines. This girl is pictured receiving an immunization before the start of the school year. Almost all schools in developed countries require that students receive a number of immunizations before beginning classes. Most vaccines are applied through injections, although some are taken orally, most notably the Sabin polio vaccine developed in the mid-1950s. Immunizations protect the body by either helping it to create new antibodies by presenting part or whole of the disease-causing agent to the person’s immune system—a long-term approach—or by providing it with active antibodies, a more temporary solution.Photo Researchers, Inc./Russell D. Curtis 

Other preparations include liquids such as linctuses and syrups to be taken by mouth, inhalations in metered-dose aerosol sprays, drops for the nose, ears, or eyes, and creams, ointments, lotions, and so on for application to the skin. Some companies make anaesthetics, or contrast media used for visualizing body structures by X-ray or nuclear magnetic resonance imaging (NMR).

Many pharmaceutical companies engage in research and development aimed at introducing new and improved treatments. In some countries, each stage of the trial of new medicines involving domestic, farm, or laboratory animals, or human beings, is subject to approval by national licensing authorities. If finally approved, a licence for a new medicine’s use in stated conditions will be issued. In some other countries permission to market may be granted on sight of the licence from the country of origin.

Patent coverage for recently developed or modified medicines is usually granted by most countries for periods averaging 15 years from the licence date. Companies give their innovations brand names, which remain their unique property. Each new drug is also given an official generic name, which remains common property. After patent expiry products may be made and sold under these generic names by any company that can meet the licensing body’s standards.

Most pharmaceutical companies operate internationally and own subsidiaries of various sizes in many countries. The old companies originated from, and have their headquarters in, either the United States, Switzerland, or a member country of the European Union. This technologically advanced industry employs many graduates, including biologists, biochemists, chemists, engineers, microbiologists, nurses, pharmacologists, doctors, physicists, and veterinary surgeons. They are employed in research and development (R & D), manufacturing, quality control, marketing, medical representation, public affairs, or general administration.

  1. STATEMENT OF PROBLEM

This has to do with the title of the project, which is the design, and implementation of a computerized Pharmacy management system for a manufacturing industry.

Due to the problem encountered with the inventory control of a pharmaceutical industries, the need arise to develop a software that will assist to solve the problem. The problem caused by the use of manual method can only be solved by computerizing the inventory processing.

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED PHARMACY MANAGEMENT SYSTEM CASE STUDY OF JAHEL PHARMACEUTICALS LTD, ENUGU