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.

Answer rating: 100% (QA)

The table will be created from the query CREATE TABLE musicalbums albumName varchar20 artistName var... View the full answer