MYSQL

Chapter 10 How to design a database Exercises 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.) 1. Use MysoL Workbench to create an EER diagram for a database that stores information about the downloads that users make. 2. a Each user must have an email address, first name, and last name. b. Each user can have one or more downloads. c. Each download must have a filename and download date/time. d. Each product can be related to one or more downloads. e. Each product must have a name. Use MysOL Workbench to open the EER diagram that you created in exercise 2. Then, exporta script that creates the database and save this script in a file named ex10-3.sql. Next, use MysOL Workbench to open this file and review it. 3. Chapter 10 How to design a database Exercises 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.) 1. Use MysoL Workbench to create an EER diagram for a database that stores information about the downloads that users make. 2. a Each user must have an email address, first name, and last name. b. Each user can have one or more downloads. c. Each download must have a filename and download date/time. d. Each product can be related to one or more downloads. e. Each product must have a name. Use MysOL Workbench to open the EER diagram that you created in exercise 2. Then, exporta script that creates the database and save this script in a file named ex10-3.sql. Next, use MysOL Workbench to open this file and review it. 3