For all problems, use the following schema: Musician(id, first_name, last name, instrument, band id Bandid, name, years together) Show(id, venue id, date) Played_in(band_id, show_id) Venue(id, name, address) Album(id, name, year, band_id, genre_id) Genrelid, name, description) Song(id, name, album_id) Primary keys are in bold, foreign keys are in italics. For each problem, write a query once using relational algebra, and again using SQL 5. Find the names of all albums by bands who have played at the venue "The Hi-Dive". 6. Find the names of all songs by bands who have played at "The Gothic" and at "The Hi-Dive" 7. Find the names of albums that fit in the genre "Reggae" by bands containing a member whose instrument is Saxophone" 8. Find the name of bands who have been together 4 or more years, AND who have an album with more than 10 songs. For all problems, use the following schema: Musician(id, first_name, last name, instrument, band id Bandid, name, years together) Show(id, venue id, date) Played_in(band_id, show_id) Venue(id, name, address) Album(id, name, year, band_id, genre_id) Genrelid, name, description) Song(id, name, album_id) Primary keys are in bold, foreign keys are in italics. For each problem, write a query once using relational algebra, and again using SQL 5. Find the names of all albums by bands who have played at the venue "The Hi-Dive". 6. Find the names of all songs by bands who have played at "The Gothic" and at "The Hi-Dive" 7. Find the names of albums that fit in the genre "Reggae" by bands containing a member whose instrument is Saxophone" 8. Find the name of bands who have been together 4 or more years, AND who have an album with more than 10 songs