ABSTRACT
This thesis portrays the Inventory Management System adequately to decide the possibility and convenience of a completed system. The main idea is to trace the trading from the sales registers with extra highlights for deciphering the information. It utilizes a server model with an associated database to permit numerous stores and other locations to be associated. This takes into account later extension while as yet supporting the focus on independent small ventures.
This thesis depicts the IMS adequately to decide the practicality and convenience of a completed framework. The center idea is to follow the offer of things from the sales registers with extra highlights for deciphering the information. It utilizes a customer worker model with an associated information base to permit various stores and distribution centers to be associated. This takes into account later development while as yet supporting the focus on private companies. Inventory Management (IMS) are generally utilized in industry these days to build the effectiveness of thin streams. The conventional technique for IMS included a great deal of administrative work, for example, a bookkeeping page and request list which will be harder to oversee as the capacity becomes greater. In this manner, IMS can be modernized to further expand the effectiveness. This undertaking intended to create IMS programming can store a huge sum of information. Additionally, it has check in/out capacity and search work that runs utilizing examine QR Code. Other than that, the product additionally has the element of low stock notice capacity to caution the client if the thing has low amounts. To build up the product, first the measures of the product are resolved by picking the product advancement devices to build up the product that can accomplish the models of the product. Next the product will be created and fixed. This paper centers on creating IMS programming for SMEs and biomedical field organization use.
Contents
CHAPTER 2: LITERATURE REVIEW 5
- INTRODUCTION 5
CHAPTER 3: REQUIREMENTS ANALYSIS AND DESIGN 13
3.2.2. Agile Development Methodology 14
- APPROACH TO CHOSEN METHODOLOGY/METHODS 15
3.8.6 Entity-Relationship Diagram (ERD) 27
CHAPTER 4: IMPLEMENTATION AND TESTING 28
- OVERVIEW 28
- MAIN FEATURES 28
- IMPLEMENTATION PROBLEMS 32
- OVERCOMING IMPLEMENTATION PROBLEMS 32
- TESTING 32
- Tests Plans (for Unit Testing, Integration Testing, and System Testing) 33
- Test Suite (for Unit Testing, Integration Testing, and System Testing) 34
- Test Traceability Matrix (for Unit Testing, Integration Testing, and System Testing) 34
- Test Report Summary (for Unit Testing, Integration Testing, and System Testing) 39
Table 4. 4 Test Summary Report 39
CHAPTER 5: DISCUSSION, CONCLUSION, AND RECOMMENDATIONS 44
LIST OF TABLES
Table 1.1: Risk and Assessment of Project Table 3.1: Developers Specification Hardware Table 3.2: Developers Specification Software Table 3.3: Developers Specification Hardware Table 3:4: Responsibility Matrix
Table 3.5 Functional Requirement Specifications Table 3.6 Non-Functional Requirement Specifications Table 4.1: Test Plan
Table 4.2Test Suite Performed Table 4.3: Test Traceability Matrix Table 4. 4 Test Summary Reports
LIST OF FIGURES
FIGURE 2 1 SILVER INVENTORY SYSTEM 8
FIGURE 2 2 ZOHO INVENTORY MANAGEMENT SYSTEM 9
FIGURE 3 1 WATERFALL MODEL (TECHTARGET 14
FIGURE 3 2 AGILE MODEL (TECHTARGET, 2011) 15
FIGURE 3 3 APPLICATION ARCHITECTURE DIAGRAM 24
FIGURE 3 4 USE CASE DIAGRAM 25
FIGURE 3 5 SEQUENCE DIAGRAM 26
FIGURE 3 6 DATAFLOW DIAGRAM LEVEL ZERO 26
FIGURE 3 7 DATAFLOW DIAGRAM LEVEL ONE 27
FIGURE 3 8 ENTITY RELATIONSHIP DIAGRAM 28
FIGURE 4 5 CUSTOMER PROFILE 31
FIGURE 4 11 ITEM ADDED TO CART 37
FIGURE 4 13 NEW STOCK ADDED 39
FIGURE 4 14 NEW CUSTOMER ADDED 39
FIGURE 4 16 OPEN IAS USING APP 42
FIGURE 4 17: RUN THE CODE USING BROWSER 42
FIGURE 4 18 SERVER DIRECTORY (DATABASE 43
LIST OF ABBREVIATIONS
CPU Central Processing Unit
ERD Entity Relationship Diagram
IT Information Technology
IMS Inventory Management System
ERD Entity Relationship Diagram
CHAPTER 1: INTRODUCTION
Overview
Walid Halal Spices is a medium scale business whose Chief Executive Officer is Mr Walid. The research is served to develop an Inventory Management System that covers the product information storage needs for Walid Halal Spice Inventory Management System. With the implementation of this prototype, the company information will be far safer and much better accessible. Companies usually keep their record manually which in this generation can be of inconvenience. In respect to this system, it will help the business run their operation smoothly with accurate and accessible data. This chapter is dedicated to fully understanding the nature of the problem and developing a solution to it. It also explains the significance of the system to the Company.
Background and Motivation
Walid Halal is one of the largest retail shops for spices in Gombe State and has gained such a wealth of reputation in the Spice industry. It has a quite reasonably sized store. Its vast interest in Spice Business spans across a wide Market Area with one Shop and a Store in Gombe. The shop offers wholesale, retail and distribution services of their products to its customers across the country. For the matter of wholesale services, it is only carried out from the shop and store while the retail services are offered at the shop where distribution services are offered in both places.
The current system for the medium scaled business was described by manual field enrollment and record based system which was vulnerable to an inordinate couple of mistakes, information repetition and the trouble of data about the items in stock are nevertheless only a couple of the difficulties the organization faces.
Statement of the Problem
Walid Halal uses a manual ledger system which brings about a lot of inconveniences and undesired drawbacks. There is a lot of time wasting since the information is first documented on hard copies then entered into a spreadsheet application. It takes a very long time to search for a particular record with the current system and lots of paper and ink are wasted which makes the system very inefficient. With flat files, data duplication is a common problem that results in all
sorts of problems such as update and delete errors just to mention but a few. Since the manual ledger system can easily be manipulated, ledger books can get lost and it also undergoes wear and tear thus leading to loss of data which is vital to the company ergo making the system insecure.
This therefore brought about a need for an Automated Inventory Management System to be put in place which would help in improving the system. The advent of an Automated Inventory Management System would thus rid of the problems nurtured by the manual ledger system used by Walid Halal Spices.
Aim and Objectives
The general objective is to implement and develop an Automated Inventory Management System (IMS) that will effectively and efficiently manage the inventory of Walid Halal Spices in their Store. To design an Automated Inventory Management System that acts as the blueprint for the new system.
To collect and analyze user requirements that was to provide the researchers with enough information of what the system users want the system to accomplish.
To test and validate the designed system that ensures all systems requirements are met.
To implement a prototype of the designed system that realizes the system designs and provides the real first taste of the actual system.
Significance of the Project
The execution of this has a great advantage to the business people dealing with goods in a way that due to the problems the companies are facing, the designed system can be more important to the company in the following ways.
The company is able to save a bit more money on expenses as it wouldn’t need to buy much paper and ink. Whereas the customers are better served as information access with the new system would be far much faster by managing your inventory. Also, the suppliers for the company also benefit as the new system makes it easier to know which items need to be restocked.
With the old system, it is quite easy to maneuver around the books and change numbers but rather, the system also goes a long way in reducing fraud as it would neatly keep track of all the assets in the company. Such that all stock, items and sales are always up to date.