AUTOMATION OF A SECURED PHARMACY INVENTORY SYSTEM WITH STOCK ALERT

ABSTRACT

This research work is concise and generally summarizes Automation Of A Secured Pharmacy Inventory System With Stock Alert.The system is designed to efficiently handle the movement and tracking of  pharmaceutical products through the replacement of human workers by technology. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. With the proposed new system, inventory can be updated in real time without product movement, scanning, or human involvement. The automated system allows inventory status to be determined and shipping and receiving documents to be generated automatically triggering automatic orders for products that are low in inventory. The study outlines the main concepts of the analysis and design methodology of the proposed system, compares it to the existing and goes further to explain the design and implementation of the system using Microsoft Access for the database. The fact finding techniques employed is interview, observation, online and library research

TABLE OF CONTENT

Chapter One: Introduction

• Introduction

• Problem Statement

• Aim of Project

• Objectives

• Scope of the Project

• Limitation of the Project

Chapter Two: Literature Review

• Review of Related Literature

• Description of the topic

• Brief History of Case Study

Chapter Three: System Analysis and Design

3.1 Analysis

3.2 System Investigation Procedure

3.3 Description of Existing System

3.4 Analysis of the Existing System

3.5Problems associated with existing system

3.6 Advantage of the New System

3.7Need to the Automation of Inventory Control System

3.8 Processes in the Automation of Inventory Control System

3.9 System Design

3.9.1 Structure Chart

3.9.2 Use Case Diagram

3.10 Database Design

3.11 Design Process

3.11.1 Input Specification

3.12 Output Specification

Chapter Four: System Implementation

4.1 Implementation Stages

4.1.1 Programming Stage

4.1.2 User Training Stage

4.2 System Requirements

4.2.1 Software Requirements

4.2.2 Hardware requirement

4.2.3 Input Requirement/Specification

4.2.4 Output Requirement/Specification

4.2.5 Non Functional Requirements

4.3 Implementation

4.4 System Testing

4.5 System Integration

4.6 Operating the New System

4.7 Error handling

Chapter Five: Summary, Conclusion and Recommendation

5.1 Summary

5.2 Recommendation

5.3 Conclusion

References

Appendix