From: Todd Kennedy <todd.kennedy@gmail.com>
To: Joe <svn@freedomcircle.net>
Cc: D'Arcy J.M. Cain <darcy@druid.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Question about One to Many relationships
Date: Fri, 24 Mar 2006 13:36:44 -0500
Message-ID: <226d83de0603241036n3795047fy412f076f23f7be1c@mail.gmail.com> (raw)
In-Reply-To: <44243BBA.8030802@freedomcircle.net>
References: <226d83de0603240852q54af3512odfce218d69718c8b@mail.gmail.com>
<20060324120142.d3fdf477.darcy@druid.net>
<226d83de0603240937o7b5608f9je5179238ee3c9c5a@mail.gmail.com>
<44243BBA.8030802@freedomcircle.net>
We're not concerned with the track info. This is a listing of album
information, hence the one to many relationship between the album and
the artist.
and for the record, i should correct myself. he said it was "bad" not "wrong".
but i hadn't given him all the details.
But. Yes. Thank you all for your help.
On 3/24/06, Joe <svn@freedomcircle.net> wrote:
> Todd Kennedy wrote:
> > They haven't responded me as of yet. There should be a band associated
> > with each album -- this is handled in code, but other than that this
> > is the only relational db way I can think of to do it.
>
> But if a band can have songs in many albums and an album can have songs
> from multiple bands, it's a many-to-many relationship, NOT one-to-many.
> Short of the full track design suggested by PFC, you'd normally
> implement a many-to-many table as follows:
>
> CREATE TABLE bands_on_album (
> band_id integer REFERENCES band (id),
> album_id integer REFERENCES albums (id),
> PRIMARY KEY (band_id, album_id)
> )
>
> This of course precludes the same band being listed twice in a given
> album. If you do need that info, then you're really asking for "tracks".
>
> Joe
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: todd.kennedy@gmail.com, svn@freedomcircle.net, darcy@druid.net
Subject: Re: Question about One to Many relationships
In-Reply-To: <226d83de0603241036n3795047fy412f076f23f7be1c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox