One post auto attached to many another items

I think the way I would tackle this would be with a custom taxonomy, maybe hierarchical, depends on the implementation. I would use the description field on the taxonomy terms to store the artist’s name, etc. If you need a more robust implementation with greater flexibility, creating the artists as another custom post type then using a dropdown or even a manual entry field on the song to select the artist would be my goto.