Draw EER diagram for this case. Cardinalities should be given to each relationship. mention inheritance,overlap,disjoint function if required.

the attributes mentioned in objective are limited. you can add more if required. Also objectives are given only as reference. You can add more entities if required but must make sense in EER diagram.

Topic: Online retail Management DRAW EER DIAGRAM WITH CARDINALITIES FOR THE GIVEN BELOW CASE 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 won't 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. of 4 294 words I English (United States) O Type here to search