Re: Multiple Parent Tables (or Multiple Inheritence, or Arc-Relationships...)

From: Bob Badour <>
Date: Thu, 13 Dec 2007 13:25:05 -0400
Message-ID: <47616af4$0$5266$>

d-42 wrote:

> Hi,
> It seems to be a common enough problem, but it doesn't seem to ever be
> properly addressed in data modelling books, and from reading on the
> web its clear that other people have had this problem as well as had
> multiple solutions presented, but its unclear what is actually the
> "right" answer.
> The problem is, suppose you have an entity: Person that has Addresses:
> The solution, two tables:
> Person { namefirst, namelast, birthdate, personid(pkey) }
> Addresses { line1, line2, city, state, postcode, country,
> addressid(pkey), personid(fkey) }
> So far, so good. Textbook.

I suggest you shelve that textbook and read another. Received on Thu Dec 13 2007 - 18:25:05 CET

Original text of this message