Smart Inventory Management System


Sample Image

Team

Table of Contents

  1. Introduction
  2. Solution Architecture
  3. Data Flow
  4. ER Diagram
  5. Relational Schema
  6. Other
  7. Links

Introduction


About

Scheduling and maintaining assets are important in an engineering laboratory, or for that matter in any laboratory. Keeping track of the usage of all the tools manually is not easy, nor efficient. Hence, we now see that there are many automated systems used in labs to assist it with its activities.

Problem

The most commonly used methods for inventory management such as file systems are hard to maintain and are often not updated frequently. In a lab therefore, you tend to lose track of the items available, and as a result not maintain them properly. Traditional laboratories also do not have facilities to make reservations in the lab. There are times when students come to the lab with the hope of using a particular machine or tool and find that it is being used by another person. This could happen to you everytime you go to the lab intending to use that instrument. You never find it vacant. Having no proper scheduling system leads to the waste of time and resources.

Solution

Our project introduces a smart inventory management system with resource scheduling. This system maintains an inventory of all tools in the lab and allows students/ lecturers to view and make reservations online for a particular item.

Solution Architecture


The Web Applciation is hosted using a remote server. The web system can be accessed by all user groups. Upon logging in, the users can access relevant pages according to the defined control flow. Accordingly, Guests, regular users(students), admins/ maintainers will be directed to their relevant pages in the site. The users will thereafter be able to use the system to make/ view reservations for a particular station in the laboratory.

Sample Image

Data Flow


Sample Image

ER Diagram


Sample Image

Relational Schema


Sample Image

Other


The layout of the MakerSpace lab

Sample Image

A station in the lab

Sample Image