cforce

t1:artists[pk(artistid),uniqueIndex(name)]
t2:albumsorsamplers[pk(albumorsamplerid),uniqueIndex(name)]
t3:songs[pk(songid),uniqueIndex(name)]

t4:song2artist[pk(song2artistid),uniqueIndex(fk(songid),fk(artistid)),playtime]
t5:artist2album[pk(fk(artistid),fk(albumorsamplerid))]
t6:song2artist2album2track[pk(song2artist2album2trackid),uniqueIndex(fk(song2artistid),fk(artistid),fk(albumorsamplerid),track)]
t7:song2artist2genrevotes[pk(fk(song2artistid),fk(genreid)),votes]
t8:cds[pk(cdid),uniqueIndex(discid,albumorsamplerid),plength,fk_t5(submitterid]
t9:cds2year2genrevotes[pk(fk(cdid),year,fk(genreid)),votes]
t10:cdtracks[pk(fk(cdid),fk(song2artistid)),offset]