How to design a database Exercises 1. Create a database diagram that shows the r

Question

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.

Explanation / Answer

Question 1)

What are the seven tables and the requirements in the question?

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

Answer)

Tables:-

User - userId(primary key), emailAddress, firstName, lastName

Download - downloadId(primary key),fileName, downloadDateTime, userId(foreign key references User-userId), productId(foreign key references Product - productId)

Product - productId(primary key), productName

Each table has been introduced with a primary key.

Download table has 2 foreign keys - each from User and Product table.

Because of the above table structure the below things in the requirements are possible:

Each user can have one or more downloads.

Each product can be related to one or more downloads

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.