View Single Post
  #3  
Old Sep 15, 2008, 11:38 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

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.
Reply With Quote