Inventory management system

Abstract

With the rapid growth of Human Computer Interaction, more and more useful software are out to replace erroneous human efforts. The system is being proposed in this report aims to manage inventory in a computerized environment rather than manually in a glass dealing enterprise. It encompasses functionalities such as report generation, order alerts e.t.c.This research examines inventory management and the role it plays in improving customer satisfaction. It looks at how glass companies have been under pressure to streamline their inventory systems, and the consequences of such actions. Many glass companies are, therefore, looking at various inventory management systems as they belief this will have a positive effect on the satisfaction of their customers. It also outlines the methodology used in the research and concludes by pointing out the limitations of the research as well as suggestions for further research.


Table of Contents

CHAPTER ONE7
1.0 INTRODUCTION7
1.1 BACKGROUND INFORMATION7
1.2 PURPOSE OF INVENTORY MANAGEMENT AUTOMATION7
1.3 JUSTIFICATION OF THE PROBLEM8
1.4 PROJECT OBJECTIVES8
1.4.1 GENERAL OBJECTIVES8
1.4.2 SPECIFIC OBJECTIVES8
1.5 LIMITATIONS OF THE SYSTEM9
1.6 ADVANTAGES OF THE SYSTEM UPON DEVELOPMENT9

CHAPTER TWO9
2.0 LITERATURE REVIEW9
2.1 INVENTORY MANAGEMENT DEFINITION10
2.2 FUNCTIONS OF INVENTORIES11
2.3 HOW INVENTORY CONTROL SYSTEMS REALLY WORKs12
2.4 AUTOMATED INVENTORY CONTROL SYSTEM SOFTWARE12
2.5 WHY INVENTORY CONTROL/MANAGEMENT AUTOMATION14
2.6 WHAT INDUSTRIES REQUIRE INVENTORY CONTROL14
2.7 WHY INVENTORY MANAGEMENT IS IMPORTANT15
2.8 The Domain15
2.9 THE CLIENT15

CHAPTER THREE15
3.0 IMPLEMENTATION METHODOLOGY15
3.1 SYSTEM ANALYSIS AND DESIGN METHODOLOGY15
3.2 DATA COLLECTION16
3.3 ANALYSIS OF THE EXISTING SYSTEM16
3.4  LIMITATION OF THE EXISTING SYSTEM16

CHAPTER FOUR17
4.0 SYSTEM ANALYSIS AND REQUIREMENT MODELLING17
4.1 SYSTEM FLOWCHART18
4.2 DATA FLOW DIAGRAM SHOWING A REPRESENTATION OF THE SYSTEM19
4.3 SEQUENCE DESIGN DIAGRAM FOR THE SYSTEM’S INTERACTION21
4.4 REQUIREMENT DEFINITIONS AND SPECIFICATIONS22
4.4.1 REQUIREMENT STATEMENT22
4.4.2 SYSTEM USERS23
4.5 CHOICE OF DEVELOPMENT TOOLS23
4.6 SYSTEM REQUIREMENTS23
4.6.1 Software Requirements23
4.6.2 Hardware Requirements23

CHAPTER FIVE24
5.0 SYSTEM DESIGN24
5.1 DATA BASE DESIGN25
5.1.1 LOGIN TABLE25
5.1.2 ORDER TABLE;SUPPLY ORDER25
5.1.3 TRANSACTION TABLE;SUPPLY FORM25
5.1.4 ORDER TABLE; SALES ORDER26
5.1.5 SALES TABLE26
5.2 PROGRAM DESIGN27
5.2.1 Implementation of the Home Form27
5.2.2 Implementation of the Main menu form28
5.2.3 Implementation of the Input forms28
5.2.4 Implementation of the report forms30
5.3 SYSTEM VALIDATION30

CHAPTER SIX30
6.0 SYSTEM IMPLEMENTATION30
6.1 CODING TOOLS30
6.2 TESTING31
6.2.1 UNIT TEST31
6.2.2 SYSTEM TEST31
6.3 EDUCATION AND TRAINING31
6.4 INTEGRATION31
6.5 CHANGEOVER TECHNIQUE32

CHAPTER SEVEN32
7.0 LIMITATIONS32
7.1 CONCLUSION33
7.2 RECOMMENDATIONS33
REFERENCES33