Hi Sinndho,

Although your design is very interesting, I fail to see how to eliminate data redundancy or how to answer a query such as, "Which songs are in the top 100?" or "List all the songs by a specific artist."

As this is my first attempt at designing a database with relationships and normalization, your approach seems to be well beyond my ability to understand it at this time.

Don't get me wrong, I really appreciate the time and effort you put in to the DB design and explaining it, it just seems too complex for me to understand.

I've found this DB on the internet that is close to what I'm looking for, but I still have one relationship issue. It's how the songs relate to the other tables.

For instance:
An Artist can have many Songs that are also on many Albums.
Shania Twain - "Any Man Of Mine" is on both "The Woman in Me" & "Greatest Hits" albums.

One Song can be performed by many Artists.
"How Do I Live" performed by both LeAnn Rimes & Trisha Yearwood

I could give several more examples, but I think that I've made my point.

Am I working in the right direction or am I missing something here? Am I over-complicating this?

Thanx for now,
Cheers,
ziggy1971