Inventory Management System

1
Inventory Management System

• Arina Ramlee, Bruce Chhay, David Henry

2
Operational Concepts

• Real-time inventory management
• Provides notification of low stock to managers
• Helps ensure that popular items remain in stock
• Does not automate restocking
• Does not interpret sales data

3
Additional Features

• Automatically email stock updates
• Records sales data for export
• Full POS integration

4
System Requirements

• Database server (MySQL)
• Web server (Tomcat)
• Emulating cash registers (JavaPOS)

5
Architecture

• Client-Server (2 different clients)
• All data at the server
• Emulated Cash Register Client
• Stock Manager Client web interface

6
Architecture (cont.)
Database (MySQL)
Cash Register Client
RMI / HTTPS
Web Server (Tomcat)
JDBC Connector / J
RMI / HTTPS
Cash Register Client
RMI / HTTPS
Cash Register Client
RMI / HTTPS
Stock Manager Client
7
Stakeholders

• Consumers
• Ensures consistent availability
• Stock manager
• Efficiency
• Small stores use single PC or internal network
• Regional franchise uses multiple client locations
  connecting to a single server

8
Schedule

• 2 weeks Design and Core Features
• 5 weeks Testing and Additional Features
• Spiral model
• Prototype
• Beta
• Release
• Each feature is an independent task

9
Feasibility Rationale

• Emulation of cash registers
• Trusting SSL for encryption
• Loss of connection to server
• Relies on following a restocking procedure
• Theft breaks synchronization between the
  inventory and the database
• Similar Products