How to design a database

Exercises

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.)

2. Design a database 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.

Submit 1- a screenshot of your database design for the Guitar Store DB to the

2- you can design your database in MS-Word if you

have it using textboxes and lines to connect the tables.

If you don't have Word you can

layout your tables in text and describe how the relationships would work.