On Wednesday 23 Nov 2005 20:03, Patrick Casey wrote: > Ok, I admit it, this is probably a stupid question, but I can't > (curiously) seem to find an answer to this in the SQL spec. > > > > Is it legal for a child table (the n side of a 0..n) > relationship to have a foreign key relationship to *more than one* parent > table? >
I can't answer you specifically - but I did a lot of datamodelling in the past and with this situation you define that car and family are subclasses of an owner entity Looking at my postgres documentation there is an INHERITS clause in CREATE TABLE, which (provided it is single inheritence) seems to be part of the SQL standard. -- Alan Chandler http://www.chandlerfamily.org.uk Open Source. It's the difference between trust and antitrust. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
