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
Get step-by-step solutions from verified subject matter experts
