Use mysql workbench to create an eer model from the script file named create_my_guitar_shop. sql that’s in the mgs_ex_starts folder. from the model, create an eer diagram that shows the relationships between the seven tables in the database. (the administrators table is not related to the other six tables.) 2. use mysql workbench to create an eer diagram for a database that stores information about the downloads that users make. each user must have an email address, first name, and last name. each user can have one or more downloads. each download must have a filename and download date/time. each product can be related to one or more downloads. each product must have a name. 3. use mysql workbench to open the eer diagram that you created in exercise 2. then, export a script that creates the database and save this script in a file named ex10-3.sql. next, use mysql workbench to open this file and review it. 4. write a script that adds an index to the my_guitar_shop database for the zip code field in the customers table. 5. write a script that implements the following design in a database named my_web_db: in the downloads table, the user_id and product_id columns are the foreign keys. include a statement to drop the database if it already exists. include statements to create and select the database. include any indexes that you think are necessary. specify the utf8 character set for all tables. specify the innodb storage engine for all tables. write a select statement that joins the three tables and retrieves the data from these tables like this: sort the results by the email address in descending sequence and the product name in ascending sequence. 6. create a view named order_item_products that returns columns from the orders, order_items, and products tables. this view should return these columns from the orders table: order_id, order_date, tax_amount, and ship_date. this view should return these columns from the order_items table: item_price, discount_amount, final_price (the discount amount subtracted from the item price), quantity, and item_total (the calculated total for the item). this view should return the product_name column from the products table. 7. create a view named product_summary that uses the view you created in exercise 6. this view should return summary information about each product. each row should include product_name, order_count (the number of times the product has been ordered) and order_total (the total sales for the product). 8. write a select statement that uses the view that you created in exercise 7 to get total sales for the five best selling products.