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 <john.l.meyer@stripped> 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:brenttech@stripped]
> Sent: Wednesday, August 02, 2006 2:13 PM
> To: Tanner Postert; mysql@stripped
> 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/mysql?unsub=1
>
>
