Ms. Chavez is interested in seeing what tracking information in a database would look like, rather than relying on Excel spreadsheets. She heard it was easier and would cut down on data redundancy. She has given you a list of music that she owns (vinyl records, cassettes, and CDs) and would like you to create a database using that information as a sample. Since you're good friends by this point, you get started on the project right away.

Objectives

Create, edit, and save a database

Create and run a Query

Apply basic formatting to a database

Create, modify and manipulate Tables in a database

Maintain a Database

Create, use and modify Forms in a database

Briefly discuss your thought process in the choices you made in creating the database.

Instructions

Ms. Chavez is interested in seeing what tracking information in a database would look like, rather than relying on Excel spreadsheets. She heard it was easier and would cut down on data redundancy. She has given you a list of music CDs that she owns and would like you to create a database using that information. She also wants to hear, briefly, your thoughts on why you chose the primary key you did and what all you did as you created the database.

You will come up with the following information to use in the database:

Fifteen album Names (real or fake) - You can use the table below as needed.

Of those fifteen albums, there should be at least two types of music (genres). These can be anything from hip-hop to classical.

Each of the fifteen albums should have their format recorded as well (CD, cassette, or record).

Name of AlbumName of ArtistGenre of MusicFormat

Once you've created that information, do the following:

Create a database to track the data.

Create at least 2 related Tables.

Create a Query showing all the music in one of the genres (for example: Jazz). Name it after that genre of music (for example: Jazz query).

Choose what your primary key will be.

Create a Report based on the Query created in the previous step.

Create a Form, using the Form Wizard to enter the information for each CD.

Upload your completed Database to the assignment folder, naming it Music Database.

In the submission comments, give a brief description of why you chose the data you did for the primary key and what process you went through as you created the database.

Your report and form should be attractive, legible, and readable.

HINTS: Start by creating the related Tables. If you changed your mind on how the Tables should be related or the fields that should be in the Tables, based on the Discussion, you may change them here – they do not have to be the same as you may have originally posted. You may use the Wizards to create the Form, Queries and Reports

 

Transcribed Image Text:

10:31 O l 19% classical. 6 Each of the fifteen albums should have their format recorded as well (CD, cassette, or record). Name of Name of Genre of Format Album Music Artist Once you've created that information, do the following: • Create a database to track the data. • Create at least 2 related Tables. • Create a Query showing all the music in one of the genres (for example: Jazz). Name it after that genre of music (for example: Jazz query). 10:31 O l 19% classical. 6 Each of the fifteen albums should have their format recorded as well (CD, cassette, or record). Name of Name of Genre of Format Album Music Artist Once you've created that information, do the following: • Create a database to track the data. • Create at least 2 related Tables. • Create a Query showing all the music in one of the genres (for example: Jazz). Name it after that genre of music (for example: Jazz query).

Answer rating: 100% (QA)

Please find the syntax below CREATE DATABASE musicdatatracking USE musicdatatracking Create Table 1 ... View the full answer