Project 1

Ans No-6

First we have created Entity Realtion (ER) diagram and given realtions to it as per the input given by the .

In SQLyog we have created database and then created the required tables like Register, customer, seller, discounts, products,administartion,categories_1, categories_2, orders, wishtlist, reviews and cart.

For tables which already created as per our code requirement for few attributes we have considered the primary key and foreign key where ever it is required.
After that we have inserted the values for all the tables as per the fields input.
And finally we have write down the queries for given inputs.