Topic: Online retail Management

Business Problem: This project aims to build a database management solution for a large-scale online retail shopping company named All-in-ALL who has 50+ stores across the Northeast USA region who are going online after a long offline presence to attract more customers.

All-in-All sells almost 1 million products and does 10 thousand daily transactions approximately. The values of products change across different stores due to state taxes. Apart from selling different brand products, All-in-All sells its own merchandise by the name of nature-valley.

All-in-All provides customers with membership cards where a user gain reward points for each transaction. A user can use his reward points to pay a certain portion of the bill. Apart from that membership customers can get free shipping on all the products. A non-membership customer can still purchase all these products he wont be able to avail of the membership services.

This project is an attempt to build a large scale database system to support approximately 1 million products and 10 thousand daily transactions without compromising about ACID (atomicity, consistency, isolation, durability) properties.

OBJECTIVES

-> Maintain a record of products stock, price, brand, product batch for all the 50+ stores

->Maintain details of sales for each store

->Details of Store No, Region, Address

->Details of Transactions (eg. type of payment used)

->Details of Customer information (login details, address, first name, last name, membership, etc)

->Details of shipping information (e.g. Shipping date, shipper name)

Features:

This database has two sides user interface and admin interface. In the user interface, customers can only see and order in the admin interface admin can update product information. An admin can be a customer at certain times when he purchases products.

DRAW EER DIAGRAM AND UML DIAGRAM FOR THIS CASE