Solved–Chapter 10– How to design a database– Solution

Description

Exercises

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. (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.

1. 1. Each user must have an email address, first name, and last name.

1. 2. Each user can have one or more downloads.

1. 3. Each download must have a filename and download date/time.

1. 4. Each product can be related to one or more downloads.

1. 5. 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.