Question: Create the database schema called music_albums which allows users to find all the music `albums on a set of user preferences. These user preferences include

Create the database schema called music_albums which allows users to find all the music `albums on a set of user preferences. These user preferences include the album name, artist name, main track name, release date and its producer. Design a schema for the database that would store this information. Use just one table.

Write the MySQL queries to perform the following:

List the albums based on the release date

Add an extra column and name it as genre

List the albums released after the particular date.

Show the data after changing the genre.

List only the main track names.

List the total no. of albums in the database.

Display the list showing the first and the last column.

List the album in the descending order.

Insert 5 tuples.

Show all the records.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!