Tracking Single and Bundled Products (Choral Music Library)
I am trying to track choral music in a music library. Some songs are single copies, yet others are members of a collection with multiple songs. The collection has it's own title. As best I can tell:
A collection has a unique title, and multiple songs.
A single song can also appear alone.
This is much like a CD, where a "single" is self titled, yet an album has multiple songs and a unique song title.
I can't figure out what tables I need to track this.