Hello my teacher. can you help me? We need to do it with mysql. Please send me diagram, table, sql queries. thanks.

We want to develop an E-commerce site and we want the system to be able to perform all the items listed below. For this reason, you need to design the required database and then create all the necessary tables and fields in the table. Data entry must be made for each table. After designing the database, you need to make all the queries listed under the SQL QUERY section. 1. The user will be able to log in to the system with a user name and password, and each user will have a user number. 2. There must be different product groups in the system. Jacket Trousers Coats Shirt 3. The number, brand, model and prices of each product will be found. 4. There will be stock information on how many of each of the products are available. 5. The address, city, telephone information of the customers to which their invoices are delivered, and the address, city, telephone and delivery person information of the products they purchased will be kept. 6. Information on each purchase made by the customers from the system so far will be available. These: a. How many products b. Which product c. At what price D. Which date SQL Queries 1. List users who are members but have not made any purchases from the system so far. 2. List the name, surname and product brand of the customers who bought Adidas Jackets. 3. List the stock information of each of the products and how many customers have bought them so far, including the products that were never sold and stock information. 4. Select any day among the sales days (Example: date=2021-12-23) and list the total product sales for at least 2 products on that date. 5. List the total number of all products sold in the last 7 days by product group.