Build a music recommendation service.

You are given a template database with genres, regions, and bands. See attached file.

Tasks:

$(9$ points$)$ Create db user called $$api$$ with limited access of read only of initially given tables in the template, and read$/$write$/$update permissions for all additional tables created for this project in the next steps.

$(9$ points$)$ Create a "User" relation. User needs an ID$,$ name, and home country.

$(9$ points$)$ Create a "Favorites" relation. Favorites needs to reference user, and bands.

$(9$ points$)$ Create a query to determine which sub$\_$genres come from which regions.

$(9$ points$)$ Create a query to determine what other bands, not currently in their favorites, are of the same sub$\_$genres as those which are.

$(9$ points$)$ Create a query to determine what other bands, not currently in their favorites, are of the same genres as those which are.

$(9$ points$)$ Create a query which finds other users who have the same band in their favorites, and list their other favorite bands.

$(9$ points$)$ Create a query to list other countries, excluding the user$$s home country, where they could travel to where they could hear the same genres as the bands in their favorites.

$(9$ points$)$ Add appropriate indexing to all tables and optimize all queries.

$(9$ points$)$ Write an application in the back end language of your choice $($BE languages only, no JS or Node$)$ to access the database using the created user in task # $1$ with a function to run each query in tasks $4-8$ with the user ID passed as a parameter where needed.