Project 1

2) Your ecommerce database should store data for the following. Design your database however you wish, provided that these functionalities should be taken care of-

1. Coupon codes with discount rule and percentage per coupon
2. Order- shipments- invoices
3. User wishlist
4. Replacements catering to different orders- status
5. Reviews from customers for every product
6. Product- name, color, seller, sizes available, quantity available, cost, current discount, place of origin for delivery calculations, isFeatured, popularityIndex, avgratings, totalratings, reviews for ratings, review country, isOnSale, categories, brands, images, questions with answers about the products, description, tags, related products ids
7. Customer- gender, dob, city, pw, name, email, delivery addresses, contacts, current and prev orders, payment info saved
8. Orders- status- cancelled/completed/ordered/packed/shipped/delivered, deliveryexpectation/deliverydate, orderdate
9. Seller- Name, mobile no, password, categories of products provided

1) 

To the ecommerce database already created, add/extend the following functionalities in your ER diagram if not present yet, create tables, normalize your design and create MySQL database with sample information in it. Remember to optimise your database to search on name, categories, date of product for latest and brand name. Reason how your design is doing this.

Submit your updated ER and tables diagrams. You can use dbdiagram.io for this. Submit all SQL queries used to define your database and insert information in it.

Reason :

• why i will design to this model means , we need a  proper way of  ecommerce ER diagram implementation
• In terms of DBMS, an entity is a table or attribute of a table in database, so by showing relationship among tables and their attributes, ER diagram shows the complete logical structure of a database.