DataMart Management System

 

Project Objective

            Today supermarkets and department stores are the epitome of globalization. They bring together goods sourced from different parts of the world and offer immense choice to each consumer. This DataMart Management System is designed to handle warehouse and inventory management tasks of such stores. The number of suppliers to modern day stores increases the complexity of the existing system as each supplier will have to be individually contacted and receipts generated and shared for each transaction. This DataMart Management System will facilitate the process of maintaining stock records, ordering new stocks and payment. It will also help suppliers and the store to track trends and statistics of sales.

The process starts with the addition of a new supplier to the system. The supplier will be able to enter the lead time, i.e. the time needed from placing the order to order delivery, for each product. Terms such as transit insurance, late delivery penalty and price per unit can be decided at this time. It will be the supplier’s responsibility to update the system with any changes in delivery times due to festive sales, holidays, etc. When the store places an order for a batch of product units, the supplier will arrange delivery within the stipulated time and will update the system with the Stock Keeping Unit (SKU) for each unit being sent. The store will confirm receipt of the units and their SKU upon delivery. The scanning of the SKU can be completed easily using a bar code scanner. The store can also set automatic ordering options, which will automatically place an order for a product once the supplies go below a specified level.

            The selling prices of the products are then decided and the product goes onto the shelves of different stores. The sales of the product can be tracked across the chain using the SKU. Whenever a product is sold or discounted or returned the SKU for the product will be required for updating the records. The store can use this data to predict stocks required in the future and the supplier can see the sales data for their products to make manufacturing decisions. Payment for the products can be completed using the system at any time. Receipts for sales will be maintained on the system and can be printed out at will.

Existing System

            The existing DataMart Management System depends on the use of paper and multiple files. Each order can be placed using phone calls or emails and will be followed by official quotations. Orders are sent and receipts generated after which payment is made. This whole process lacks the flexibility and agility required to succeed in today’s fast paced market. Disputes can arise due to mismatch of records and tracking the sales of each unit is a herculean task.

Proposed System

            The proposed DataMart Management System will speed up the process and will make it more responsive to customer demands. Delays in payments and ordering can be eliminated by the presence of this electronic system that will maintain a shared and tamper proof record. The supplier and store can predict changes in demand and plan accordingly. Defects in any batch of the product can be easily tracked due to the use of SKUs.

Modules

Admin: The admin module will make access IDs for each supplier and will be able to access sales data over the whole chain of stores. Payments to the suppliers and setting of prices will also be done here.

Store: Each store in the chain will have a user ID to access this module. Through this module they will be able to set how many stocks they require from the warehouse, they can also see sales data for their store and notify the central office about defects or returns of products.

Supplier: The supplier will be able to confirm terms of sale with the admin and confirm orders on the system. They will receive payment via this system and can view the receipts on the system. The supplier can also see sales data for each product to gauge its demand.

Software Requirements

• Windows XP
• Apache Tomcat Web Server
• Oracle

Technology Used

• Java

Hardware Requirements

• Hard Disk – 2 GB
• Monitor
• RAM – 1 GB
• Keyboard
• Printer
• Processor – Dual Core or Above
• Mouse

Download Project

Abstract Download	Download Abstract
DataMart Management System  Database	Download Database
DataMart Management System Source Code	Download Source Code