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.
You can treat single songs as a "collection" of just one song.
Collections::CollectionID = Songs::CollectionID
where CollectionID is a serial number field.
With "single song collection", the collection and song titles would be the same.