DataMart Management Software

ABSTRACT

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.

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 Systemwill 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.

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

1.Administrator

2.Sub-Location In-charge

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

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 Sublocation Incharge,  Retailer.

Hardware Requirements:

Processor                                                Pentium III

Speed                                                      800 MHz

Monitor                                                   EGI/VGA

Hard Disk                                               20 GB

RAM                                                      128 M B

Mouse                                                     Logitech

Key board                                               TVS

Software Requirements:

Operating System                                 Windows NT

Languages                                             Java 2.0, Jsp, Jdbc, Pramati

Application Server 3.0

Web Technologies                                HTML, JavaScript.

Back End                                              Oracle 8.0

Documentation Tool                             Microsoft word 2000