just to clarify to Brent, the songs lists the original artist and album. the CD table is for the information for a NEW mix CD. that CD contains the tracks listed in the tracks table, which point back to the individual songs. the reason the tracks are not listed in the songs table, is because they can be part of multiple CDs. one person could put that same song on tons of different mix CDs as wells as other users using it too, anyways, thanks for the help, i'll let you know how your suggestions faired.
On 8/2/06, John Meyer <[EMAIL PROTECTED]> wrote:
I've dealt with this in terms of Books and Titles. Those two are separate: one title can have many book editions published in it. Also, you can have a book with multiple titles (anthology, for instance). I suppose it is possible for album not to be the same as cd title, particularly if you have old vinyl albums around that you want to sell. -----Original Message----- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 2:13 PM To: Tanner Postert; mysql@lists.mysql.com Subject: Re: Is this query possible? I'm not sure why you split out track, track is really kind of an attribute of a song. Especially since you have artist and album with the song. Wouldn't album be the same as cd title? I'm not quite getting the logic of your schema. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
