Design and Implementation of a Web Based Pharmaceutical Management Information System

Design and Implementation of a Web Based Pharmaceutical Management Information System

Project / Seminar Material
Reference ID: PS-5666-TM

DEDICATION

This research material titled “Design and Implementation of a Web Based Pharmaceutical Management Information System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of a Web Based Pharmaceutical Management Information System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    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 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    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.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    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”

    ABSTRACT

    Pharmacist product drugs and drug are drug production is not an easy task, starting from the raw materials composition through labeling and packaging to sales and maintenance of the produced drugs.

    This research study ventured into the pharmaceutical activities, critically analyzing the entire pharmaceutical work flow carefully identifying the problems facing a pharmacist from start till finish of their work. The identified problems were carefully looked into and possible solutions were used and adopted in the new computerized system design by the research.

    This system design will aid the pharmacist in raw material composition, information on drug, labeling and packing, storage, expiration and manufacturing date, online sales and stock control. The new system is very comprehensive, easy to use, cost effective, accurate and timely in report generation. Pharmacist will breath in fresh air, enjoy their job and reap a lot of game while using this new computerized design.


    Design and Implementation of a Web Based Pharmaceutical Management Information System

    CHAPTER ONE


    Introduction

    Pharmaceutical management is not a new concept in the country, there are a lot of pharmaceutical companies scattered a cross the country and their major vole is drug being sold to people by either chemist shops or pharmaceutical shops. This is due to lack of adequate pharmaceutical control management system. The pharmaceutical job is a very sensitive one, it requires a lot of standards and carefulness’ because the drugs they produce directly affects human health.

    Reliable pharmaceutical companies have been in the process of producing drugs and majority of them has, been performing very well, especially Pfizer pharmaceutical company, but as the world develops they are faced with a lot of challenges, which requires sophisticated system to tackle the problems. The existing system in Pfizer plc require some modification in other to meet up with the modind currently attainable in the society and to equally find it’s feet’s in the competitive market.

    Where drugs are proceeding in large quantity, it is always a difficult task to maintain the drugs in the ares of sales, stock control expiration monitory and raw material composition composition. a availability of drugs should be readily ascertained and reorder level be timely and orderly, sales balance will be managed effectively. All these compelled the researcher to take up this task and make the general society to benefit immensely form the reorder level.

    − To produce a system that will be action to produce a system that will effectively monitor drugs sales and customer services and comfortably maintain an accurate account states.

    1.1 Purpose Of Study

    This study was carried out in other to provide lasting solution to the problems allocated with the existing system. The solution will be automatic and very comprehensive.


    1.2 Importance Of Study

    This study is very relevant in a number of ways a lot of interest groups will benefit from it. The researcher through this study has been exposed to the practical area of studies. Future research will see this as a reference document and it will help them a lot. The Pfizer plc and other interested pharmaceutical companies will through this work improve on the quality of their products and ease the burden of the staff and most especially the problems pharmaceutical companies encounter. It will also help them to maximize profit.


    1.3 Scope Of Study

    This research work, due to time factor was limited only to Pfizer plc and it will unfold the areas of drug material component, stock control outline sales and product of the work. The pharmaceutical industries will specially enjoy and appreciate this work when fully implemented.


    1.4 Statement Of The Problem

    Due to the rapid development experienced in the world today, the current system in use at Pfizer plc is gradually been over by events.

    Due to problem of raw material useage some companies’ produce a lot of take drugs fact that there is no take and control over produced drugs.

    Drug out of stock is also experienced just to the fact that the stock control system in use is not so effective.


    1.5 Aim/Objective Of The Study

    The primary aim of this project work is to produce a new computerized system that will automatically handle pharmaceutical management control system. The major objective of the study includes.

    1. To produce a system that will be cost effective
    2. To produce a system that will automatically maintain drugs and monitor the expiration of drugs.
    3. To produce a system that will an automatically prompt for more drugs when the drugs are getting our of stock.

    1.6 Definition Of Terms


    Expiration Date:

    The ending period o time that something becomes invalid.


    Information:

    Processed data facts told or discovered about sometimes.


    Data:

    Raw fact collected to be analyzed to produce information.


    Record:

    To put down/permanent account especially of a document or on computer of facts and events.


    Stock control:

    The ability in checks and balance the amount of products (stock) in a company’s warehouse.


    Online sales:

    Transaction done via the use of the computer e.g. interment.


    Transaction:

    A business deal carried out or done.


    Competitive market:

    A forum where different business organizations are striving to be the best in terms of quality sales etc. expiration data monitoring and decision taking.


    1.7 Assumptions:

    If the new system is implemented and followed strictly, there will be enhanced productivity in Pfizer plc work procedure. The staff will benefit both mentally and materially.

    With this design, Pfizer plc will beat all unbeatable giants the pharmaceutical industry.

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of a Web Based Pharmaceutical Management Information System