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
Contents