Design and Implementation of a Computerized Standard Appraisal System for Pharmaceutical Products

Design and Implementation of a Computerized Standard Appraisal System for Pharmaceutical Products

ABSTRACT

In Nigeria, National Agency for Food and Drug Administration and Control (NAFDAC) has the mandate to regulate and control the manufacture, importation, exportation, distribution, advertisement, sale and use of Food, Drugs, Cosmetics, Medical Devices, Chemical, Packaged Water and other drinks. This project work researched into the procedures and criteria involved in the appraisal of pharmaceutical products by NAFDAC Nigeria. Drugs and other pharmaceutical products are specialized commodities to be used in critical situations. As such, quality of such products must be assured at all times. This is where a computerized appraisal system for pharmaceutical products comes to play.

This project work helps the Agency achieve their aim with ease. This design is more accurate and reliable it will try to bring in techniques of modern operations into the computerization of the pharmaceutical products appraisal. Due to inevitable constraints, this work is restricted to a particular product in terms of the program design.

TABLE OF CONTENTS

Title Page

Abstract

Organization of Work

Table of Content

CHAPTER ONE: INTRODUCTION

1.1 Background of Study

1.2 Statement of Problem

1.3 Purpose of Study

1.4 Aims and Objectives

1.5 Scope

1.6 Limitation

1.7 Assumptions

1.8 Definition of Terms

CHAPTER TWO

LITERATURE REVIEW

CHAPTER THREE: DESCRIPTION AND ANALYSIS OF THE EXISTING SYSTEM

3.1 Fact Finding Methods Used

3.2 Organizational Structure

3.3 Objectives of the Existing System

3.4 Input Analysis

3.5 Output Analysis

3.6 Process Analysis

3.7 Information Flow Diagram

3.8 Problems of the Existing System

3.9 Justification for the New System

CHAPTER FOUR: DESIGN OF THE NEW SYSTEM

4.1 Output Specifications and Design

4.2 Input Specifications and Design

4.3 File Design

4.4 Procedure Chart

4.5 System Flow Chart

4.6 System Requirements

CHAPTER FIVE: IMPLEMENTATION

5.1 Program Design

5.2 Program Flow Chart

5.3 Pseudocodes

5.4 Source Program

5.5 Test Run

CHAPTER SIX: DOCUMENTATION

6.1 System Documentation

6.2 Program Documentation

6.3 User Documentation

CHAPTER SEVEN: CONCLUSION AND RECOMMENDATION

7.1 Conclusion

7.2 Recommendation

References

CHAPTER ONE

INTRODUCTION

1.1 BACKGROUND OF THE STUDY

The search for excellences begins with a search for what one needs to achieve one’s personal best, the search ahs led to discovery of many tools to improve human efficiency. Computer invention leads this class. Since the advent in the mid 40’s the problem has become how to use computer truly for human endeavour. Initially, it was used as guides towards improving administrative performances, today the shift is on the side of the computer making decision and improving operation performance directly. Since in the decision making, computer approach was enhanced with advancement in operation research management science, quantitative techniques in solving modern day problem using computers.

Decisions are basically made daily on raw materials inventory engineering spare parts, procurement and contend if personal etc. these decisions are supposed to be made from the interpretation of processed data. This is however, not usually the case.

Some operations like job sequencing on machines, potency test on things at regular intervals, careful monitoring of inventory level, efficient scheduling of machine maintenance requires computer aids for good productivity. This is unfortunately lacking. Considering pharmaceutical products in relation to the National Agency for food and Drug Administration and Control (NAFDAC), information storage and retrieval with adequate, processing and the base of their work flow information on drug and the nature of such drug attracts importance more than every other operation.

1.2 STATEMENT OF THE PROBLEM

The existing system is not meeting its objectives due to problem associated with it. These problems hinder the smooth operation of the system. The existing system, is not flexible. The method of information storage and retrieval is very tedious. It does not make room for adequate modification of information. The system does not prompt for notification of a particular entry when a re-entry is made. The system does not generate report in time. It wastes a lot of time in report generation. This hinders success decision by managers; directors or other head of councils. The system is very expensive to maintain and the operations are difficult to carry out. Due to the volume of data involved and the complex repots to tackle, the staff find it difficult to produce accurate result.

1.3 PURPOSE OF THE STUDY

This project work is carried out to make sure that maximum appraisal and security check in the agency (NAFDAC). It also proves the usefulness of computer in the case study. It will also enlighten the student in the course of studying relating to other fields of life. This project will also provide detailed information on the concept of counterfeit pharmaceutical product. The importance of appraising this products and the importance of computer in the field. The major purpose is to effect a computerized design which will tackle the operation of appraising pharmaceutical products in an automatic manner.

1.4 AIMS AND OBJECTIVES

The objectives of this product work is to look into the operations involved in creating a standard appraisal system for pharmaceutical product with a view of detecting the problems facing the system, providing possible solution to the problems and to modify and develop a new system that will carry out the activities in an automatic manner.

The research is also aimed at reducing cost of maintaining the system and to improve in work operation of appraisal by keeping adequate records, enabling easy retrieval and update and also enhancing speedy processing.

1.5 SCOPE OF THE STUDY

This project work is designed to take care of a standard appraisal system for pharmaceutical products in NAFDAC Nigeria. It keeps adequate records of appraised drugs or products and the registration numbers respectively. The design accept information about such product, stores them and generate adequate result when needed.