[theList] Music Database
fstorr
fffrancis at fstorr.demon.co.uk
Mon Jun 16 15:20:56 CDT 2003
> I'm still up in the air on this one, but I'm starting to
> think that The Band should have a many-to-many link to the Recording.
That way
> multiple Bands can work on the same Recording, such as "Queen" and
> "David Bowie - solo" recording "Under Pressure". Whole albums have
> been done this way, as well, such as Band "Concrete Blonde" and Band
> "Los Illegales" doing an album together. This also allows for whole
> albums of Duets, such as Frank Sinatra's "Duets" Albums.
+++++
To me, this sounds logical. It doesn't happen that often (Billy
Bragg/Wilco are the only full albums that spring to mind straight away)
but would be necessary.
> FOR THE RECORD: Though I think I'm pretty strong on the theory, I
> have never actually put together a database this complex before.
> Someone with more direct experience with Big Uglies like this sucker
> might have different insight into non-obvious problems that can arise
> from this type of structure....
+++++
I'm not particularly strong on either, hench my original question :)
Can I just further enhance my ignorance here before I go back to my
hefty MySQL tome and ask what MB and AR joins are?
Kind regards
Francis
More information about the thelist
mailing list