With this design, redbooks won't be in the album database at all, since they'll be associated with product entries rather than album entries. It's a multi-tier design -- the track database can store any kind of music information whether it's contained in game data or on physical media; the media table organizes a subset of tracks into an ordered list, and both the product and album tables further organize subsets of media.
In fact, you could probably directly associate tracks with products, skipping media and albums entirely. There's the possibility of creating yet another table between tracks and products in order to organize such "free-floating" music info into something more coherent.
|