DataMart Management

This DataMart Management Software project mainly deals with automating the tasks of maintaining and transacting the goods.In the Warehouse System inventory management is the key process.This process includes the activities such as maintenance of stock details, maintenance of receipts and items etc. It is a tedious job to maintain all these details manually. Hence we opted to automate the Warehouse Management System.

DataMart Management Systemautomates the job of warehouse system.   It mainly includes five members .

1.                  Administrator

2.                  Sub-Location In-charge

      3.       Retailer

1.           Supplier

2.           Customer

The Administrator has the priviligies to maintain different types of Products, Suppliers, Sub Location Incharges Databases in the warehouse.He is concerned with registration of Suppliers, Sub-Location In-charge, and Addition of Products. 

The Sub location Incharges has privilige to maintain Products which are transformed from Administrator and registration of Retailers and all operations on these two databases .

The Retailer has priviligies to maintain Products at the corrosponding Retailer

The supplier has priviligies to maintain  parts Database and he can add parts and delete parts

 In this DataMart Management Software has 5 Modules

These are

1.      Master maintenance

2.      Receiving

3.      Shipment

4.      Billing

5.      Reports

System Analysis is first stage according to System Development Life Cycle model. This System Analysis is a process that starts with the analyst.

Analysis is a detailed study of the various operations performed by a system and their relationships within and outside the system.  One aspect of analysis is defining the boundaries of the system and determining whether or not a candidate should consider other related systems.  During analysis, data is collected from the available files, decision points, and transactions handled by the present system.

Logical system models and tools are used in analysis. Training, experience, and common sense are required for collection of the information needed to do the analysis.

EXISTING SYSTEM

This DataMart Management System project mainly deals with automating the tasks of maintaining and transacting the goods.In the DataMart Management Systeminventory management is the key process.This process includes the activities such as maintenance of stock details, maintenance of receipts and items etc. It is a tedious job to maintain all these details manually. Hence we opted to automate the Warehouse Management System.

DataMart Management Systemautomates the job of warehouse system.   It mainly includes five members .

1.        Administrator

2.        Sub-Location In-charge

3.        Retailer

4.        Supplier

5.        Customer

Any DataMart Management Systemmainly deals with the following processes.

1.        Registration of members

2.        Ordering items

3.        Acquiring items, Receipts

4.        Transferring items

5.        Selling items and generating bills

6.       Generating reports

The Administrator has the privilege to maintain different types of items in the warehouse.He is concerned with registration of Suppliers, Sub-Location In-charges.  He maintains the reports of suppliers who are eligible to supply the items. He can send the purchase order to above suppliers when items are required. He is responsible to add receipts when items delivered to the warehouse.He is also responsible to send the items to sub-location in-charges on demand. He deals with adding of new items and generating reports on items, orders, receipts and stock ctc.

Sub-location In-charge is registered and verified by the administrator. He is responsible to maintain the items for transferring them to Retailers on demand.   He can send purchase order to Administrator for getting items that are required for retailers. He can ship the items to retailer when he got the purchase order from retailer.   He deals with generating reports on items, orders and stock etc.

Retailer is registered and verified by sub-location in-charge. He is responsible to maintain the items for selling to customers.   He can send purchase order to Sub-location In-charge for getting items that are required for customers.   He deals with generating reports on items, orders, bills and stock etc.

The supplier supplies the items based on the order provided by the administrator.

The customer receives the bills from the retailer based on his purchases.

This project fulfills the desires of users to enhance the communication among different type of people such as administrator and Sub location In-charge, Retailer.

Problem Statement

This DataMart Management Software project mainly deals with automating the tasks of maintaining and transacting the goods. In the DataMart Management System Inventory management is the key process. This process includes the activities such as maintenance of stock details, maintenance of receipts and items etc. It is a tedious job to maintain all these details manually. Hence we opted to automate the Warehouse Management System.

 

This system maintain the all the goods at Administrator, Sublocation –Incharge, and Retailer and also maintain parts at suppliers and his data. So it will take lot of time time to retriving even single line of data or deleting data

By manually the DataMart Management System will face difficulties while updations and it is time consuming and leads more errors.

Proposed System

  Proposed system are those that are automated, so that it is easy to retrieve the responses from the system fastly and updating the details once the response or services are provided to the end-users upon their request without any difficulty and saves time.

REQURIEMENTS ANALYSIS

The requirement phase basically consists of three activities:

1.      Requirement Analysis

2.      Requirement Specification

3.      Requirement Validation

Requirement Analysis:

     Requirement Analysis is a software engineering task that bridges the gap between system level software allocation and software design. It provides the system engineer to specify software function and performance, indicate software’s interface with the other system elements and establish constraints that software must meet.

     The basic aim of this stage is to obtain a clear picture of the needs and requirements of the end-user and also the organization. Analysis involves interaction between the clients and the analysis. Usually analysts research a problem from any questions asked and reading existing documents. The analysts have to uncover the real needs of the user even if they don’t know them clearly. During analysis it is essential that a complete and consistent set of specifications emerge for the system. Here it is essential to resolve the contradictions that could emerge from information got from various parties.

This is essential to ensure that the final specifications are consistent.

It may be divided into 5 areas of effort.

1.      Problem recognition

2.      Evaluation and synthesis

3.      Modeling

4.      Specification

5.      Review

Each Requirement analysis method has a unique point of view. However all analysis methods are related by a set of operational principles. They are:

·        The information domain of the problem must be represented and understood.

·        The functions that the software is to perform must be defined.

·        The behavior of the software as a consequence of external events must be defined.

·        The models that depict information, function and behavior must be  partitioned in a hierarchical or layered fashion.

·        The analysis process must move from essential information to implementation detail.

MODULE DISCRIPTION

 DataMart Management System mainly consists of five modules ...

1.          Master maintenance

2.          Receiving

3.          Shipment

4.          Billing

5.          Reports

Master Maintenance :

DataMart Management Systemmaintains the following master details for various purposes.

i)          Suppliers Details

ii)         Sublocation Incharges Details

iii)        Retailers Details

iv)                  Products Details

Receiving :

DataMart Management Systemreceives the stock in a validated manner against Purchase Order & Receipt No. Warehouse management receiving process includes all the items necessary to receive, from unloading the trucks to recording the account. DataMart Management Systemcan perform the following receiving tasks ...

i)                    Purchase Order

ii)                  Goods Order

Shipment :

DataMart Management Systemprovides you a number of functions to maintain the flow of goods in warehouse.

The following tasks are caused under this module ...

i)          Transfer inventory

ii)         Put inventory on hold

iii)        View inventory balances

iv)        View inventory transactions

Billing :

Warehouse billing process allows the retailer to generate new bills and also allows viewing of existing bills.

Reports :

The reports process allows the user to produce the reports necessary for day to day warehouse operations. The standard reports are ...

i)         Inventory Reports

ii)        Purchase Order Reports

iii)        Administrative Reports

GOALS AND OBJECTIVES

Goals:

To automate the WMS in an easy and efficient manner.

To make the jobs of admin, sub-location, retailer easy and  trouble free.

To make the application user friendly.

Objectives:

To acquire up to date details about inventory.

To know the status of the Warehouse System.

To reduce the errors those are occurred in the manual system.

To generate the reports as per the management requirements.

To help in ordering of required items.

To provide maximum services to the users.

HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS                              

PROCESSOR    :  Intel 2.0 GHz or above

HARD DISK     :  80 GB

RAM                 :    512 MB RAM.

   SOFTWARE REQUIREMENTS

OPERATING SYSTEM                     : WINDOWS XP with SP2. 

LANGUAGE (FRONT END)   : JAVA (JDK1.5/1.6)

SERVER                                     : APACHE TOMCAT 5.5/6.0

WEB TECHNOLOGY              : HTML, JAVASCRIPT, CSS.

DATABASE (BACK END)        : ORACLE 10G.

ARCHITECTURE                      : 3-TIER ARCHITECTURE.