Inventory Analyzer (Java projects)

ABSTRACT

Inventory Analyzer is an online software application which fulfills the requirement of a typical Stock Analysis in various godowns. It provides the interface to users in a graphical way to manage the daily transactions as well as historical data. Also provides the management reports like monthly inwards, monthly deliveries and monthly returns.

This application maintains the centralized database so that any changes done at a location reflects immediately. This is an online tool so more than one user can login into system and use the tool simultaneously.

The aim of this application is to reduce the manual effort needed to manage transactions and historical data used in various godowns. Also this application provides an interface to users to view the details like the daily Stock Statements of all godowns.

EXISTING SYSTEM:

Current system is a manual one in which users are maintaining ledgers, books etc to store the information like suppliers details, inwards, deliveries and returns of items in all godowns, customer details as well as employee details. It is very difficult to maintain historical data. Also regular investments need to purchase stationary every year.

Disadvantages:

     The following are the disadvantages of current system

1. It is difficult to maintain important information in books
2. More manual hours need to generate required reports
3. It is tedious to manage historical data which needs much space to keep all the previous years ledgers, books etc
4. Daily transactions are to be entering into different books immediately to avoid conflicts which are very difficult.

PROPOSED SYSTEM:

Proposed system is a software application which avoids more manual hours that need to spend in record keeping and generating reports. This application keeps the data in a centralized way which is available to all the users simultaneously. It is very easy to manage historical data in database. No specific training is required for the employees to use this application. They can easily use the tool that decreases manual hours spending for normal things and hence increases the performance. As the data is centralized it is very easy to maintain the stocks of the various items in all godowns. 

Advantages:

The following are the advantages of proposed system

• Easy to manage all the daily transactions
• Can generate required reports easily
• Easy to manage historical data in a secure manner
• Centralized database helps in avoiding conflicts
• Easy to use GUI that does not requires specific training.

Features to Be Implemented

• Session management
• Connection pooling
• Normalized database
• Prevention of duplication login
• Design patterns
• Three-tier architecture
• Maintainability
• Easy deployment with Ant script
• Exception handling
• Client-side validations

SYSTEM REQUIREMENT SPECIFICATION:

Software Requirements:

Web Presentation                          :           HTML, CSS

Client – side Scripting                  :           JavaScript

Programming Language                :           Java

Web based Technologies              :           JNDI, Servlets, and JSP

Database Connectivity API          :           JDBC

Backend Database                                    :           Oracle/SQL Server/MY SQL/MS Access

Operating System                         :           Windows XP/2003/2007,

J2EE Web/Application Server      :           Tomcat 6.0

IDEs                                              :           Eclipse with My Eclipse plugins/Net Beans/RAD

Browser                                         :           IE/Mozilla

Hardware Requirements:

Pentium processor                   :           233 MHZ or above

RAM Capacity                        :           1GB

Hard Disk                               :           20GB

Floppy disk                             :           1.44 MB

CD-ROM Drive                      :           32 HZ

KEYBOARD                         :           108 Standard