Hello all,
I'm working on a new music collection DB and I seem to be stuck with some issues. First of all, I did look at the "Music Collection Database" available at Microsoft and it seems to me that the approach taken of that DB is of an "Album's" perspective.
For instance, data is recorded on a "per-album" basis and as such, when scrolling through the listing, you can see the same Artist several times with different Albums.
I, on the other hand, would like it to be from a different perspective.
- Enter each Artist only once
- Enter each Song only once (Although one song may also appear on many albums by the same artist, "Greatest Hits", for example.)
- Enter each Album only once
- Be able to enter a song or artist without any other info (sometimes you hear a song, but don't know the artist)
- One song, many artists ("How Do I Live" performed by Trisha Yearwood & LeAnn Rimes)
- Be able to search for:
- All Artists
- All Songs
- Songs by Artist
- Songs on Album
- Songs on Charts (Top 100, etc.)
- Songs by Genre
- Artists by Genre
- etc.
- Be able to enter a song or artist without any other info (sometimes you hear a song, but don't know the artist, e.g. Braveheart Theme)
- One song, many artists ("How Do I Live" performed by Trisha Yearwood & LeAnn Rimes)
- The list of criteria goes on & on, but I think you get the point
I've attached a copy of the DB, which is very basic at this point because I can't seem to figure out how the relationships should be placed to achieve the above listed criteria.
Also, do I need a separate "Charts" table to record which songs are on a listing, for instance "Top 100 Country Songs"?
Any information or assistance is greatly appreciated,
Thanx for now,
Cheers,
ziggy1971