Programming Homework Help

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