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

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