Re: Foreign key(s) in a single child table relating to multiple parents

> There are multiple parent tables (let's say [upto] 5) that require a
> relatiionship to a single set of attributes ([0,] 1 to many).
> How would you handle this?

Because your cookie isn't retangular, when you try to corner one with an RDM cookie cutter, you're either gonna cut of the ginger man's arm or there's gonna be some space leftover to party with NULLs :)

Alternatively, there is a small experimental db that allows each thing to have a variable number of parents and attributes. See www.xdb1.com/Example/Ex102.asp where persons related to a baseball team have different roles and attributes. Received on Sun Feb 15 2004 - 17:08:09 CET