[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


More information about the thelist mailing list