I built a website which revolved around music. I had three custom post types. Artist (or band/group), Album, and Song. The artist and album CPTs were synced with a custom taxonomy. (Example: the post title of the "artists" CPT, would be inserted as a term in the "artists" taxonomy.) So each of the CPT's post title would be inserted as a term in the appropriate custom taxonomy.
When you publish a song for example, you could then just select the proper artist and album from the taxonomies.
Then when you output the data on the front end, you could just loop song posts (or if it's single, jus…