Project 1

All the solutions for the tasks and er diagram mentioned above are put inside the Project_1.zip file

• Inside Project_1 we have an er-diagram in Ecommerse.drawio file
• and task 1 in Task_1.sql files
• similarly, task 2 in Task_2.sql files
• and task 3 in the Task_3.sql file

Note: the remaining functionality which was given after is in the Task_2.sql file

Details about project:-

• It is the backend of any e-commerce website,
• in which how the data of customer, seller , admin, products , and order details are store in the form of tables
• how to create these tables, and how to insert data into them and how to fetch the relevant data from the tables.