(a) (15 points) You've decided to store more information about artists and albums. Specifically, for artists, you want to store the names of people who have worked with the artist (for example, vocalists, guitarists, trumpeters, and drummers), when they began working with the artist, and when they stopped working with the artist (if they have done so). For albums, you want to store the name of the album producer, when the album was released, and where the album was recorded. Update your MySQL tables or columns that can store this information. Choose the appropriate column data types as per need. You need to submit updated mySQL code in separate file (sql) and also include your command line prompt screen shot after the execution of the code. (b) (5 points) Write a join query that displays the name of each artist and the (c) (5 points) Repeat part (b), but now display only those albums that have (d) (5 points) Repeat part (b) but write it as a nested query albums they've made. Alongside the album, display the number of tracks on the album. more than 10 tracks. (e) (10 points) What queries (design yourself) on question-1 database so that you could use following keywords in each query, selecting from ANY, ALL, EXISTS (or NOT EXISTS), and IN (or NOT IN) () (15 points) Using the monitor (command line, interactive mode), create a table with the following statement CREATE TABLE exercise (field1 INT(3); Using the ALTER TABLE statement, make field1 the primary key, carrying out any additional steps you need to make this possible. Add a second column, field2, of type CHAR (64) with a DEFAULT value. Also, create an index on a prefix of 10 characters from field2. You need to submit your screen shot after successful execution of all required code. (a) (15 points) You've decided to store more information about artists and albums. Specifically, for artists, you want to store the names of people who have worked with the artist (for example, vocalists, guitarists, trumpeters, and drummers), when they began working with the artist, and when they stopped working with the artist (if they have done so). For albums, you want to store the name of the album producer, when the album was released, and where the album was recorded. Update your MySQL tables or columns that can store this information. Choose the appropriate column data types as per need. You need to submit updated mySQL code in separate file (sql) and also include your command line prompt screen shot after the execution of the code. (b) (5 points) Write a join query that displays the name of each artist and the (c) (5 points) Repeat part (b), but now display only those albums that have (d) (5 points) Repeat part (b) but write it as a nested query albums they've made. Alongside the album, display the number of tracks on the album. more than 10 tracks. (e) (10 points) What queries (design yourself) on question-1 database so that you could use following keywords in each query, selecting from ANY, ALL, EXISTS (or NOT EXISTS), and IN (or NOT IN) () (15 points) Using the monitor (command line, interactive mode), create a table with the following statement CREATE TABLE exercise (field1 INT(3); Using the ALTER TABLE statement, make field1 the primary key, carrying out any additional steps you need to make this possible. Add a second column, field2, of type CHAR (64) with a DEFAULT value. Also, create an index on a prefix of 10 characters from field2. You need to submit your screen shot after successful execution of all required code