Automated Inventory Management

concepcionsockSoftware and s/w Development

Aug 15, 2012 (5 years and 1 month ago)

219 views

Automated Inventory
Management

Chao Li

CS 491A Winter 06

Introduction

AIM ( Automated Inventory Management)

To replace traditional management of a
restaurant’s liquor inventory with more
efficient AIM.

To learn and design powerful user
interface.

To gain experience of real
-
time database
design and maintenance.


Technology Approach

Stand
-
alone application combined with
front
-
end and backend.

Front
-
end


Easy
-
to
-
use interface guides the users to manage inventory,
generate sales report, and analysis customer needs.

Backend



DBMS stores inventory items, sales info.


Platform

Language: Java

Library: javax.swing, java.awt, java.sql.

Database: MySQL

Open Source: netBeans

Starting from the ground.


Status

Completed


Relational modeling. Working environment set up (netBeans and
MySQL).


To Be Completed


Interface implementation, database connection, project refinement.