Project 1

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

I am completed the project ecommerse database in the above given instructions and orders file as be uploaded as : ecommerse_store.sql and some screenshots.