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

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 13 Dec 2007 13:25:05 -0400
Message-ID: <47616af4$0$5266$9a566e8b@news.aliant.net>

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 - 11:25:05 CST