You can register a custom post type called songs or albums.
- Learn more about custom post type registration here:
https://codex.wordpress.org/Function_Reference/register_post_type - More info on Post Type: https://codex.wordpress.org/Post_Types
You can register custom taxonomies in WordPress as well.
- Learn about taxonomies here: https://codex.wordpress.org/Taxonomies
- Learn about taxonomy registration here:
https://codex.wordpress.org/Function_Reference/register_taxonomy
You can then associate songs or albums with an artist. This can be achieved quite easily by using the two following tools.
Adding the output to your functions.php.
If you want to query your new post type you can use WP_Query.
Read more on it here: https://codex.wordpress.org/Class_Reference/WP_Query
Simple tool to generate a WP_Query – https://generatewp.com/wp_query/