1. 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.
2. Use MySQL Workbench to create an EER model for a database that stores information about the
downloads that users make. (When you create the EER model, it will be given a default name of
mydb change this name to step2.) Define the tables that are necessary to implement this data
structure:
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.
When you’re done defining the tables, create a diagram for the database. Then, use the diagram to
define the required relationships. When you do that, be sure to use the relationship button that uses
existing columns.
3. Use MySQL Workbench to open the EER model that you created in exercise 2. Then, export a script
that creates the database. Use all the default options, and save the script in a file named step3.sql.
Next, use MySQL Workbench to open this file and review it.
