Re: circular relationships ok?

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 3 Mar 2006 15:40:26 -0800
Message-ID: <1141429226.587835.183320@j33g2000cwa.googlegroups.com>

Gene Wirchenko wrote:
> >
> >This line of reasoning doesn't work for me at all. The question
> >was whether to put data items which are exactly-one-to-exactly-one
> >in the same table; it is not relevant to argue that you might not
> >want to do so because they might not be exactly-one-to-exactly-one.
>
> If the persons table has information on both married and
> unmarried persons and there is a table about marriages, where do you
> think the brithdates should go?

If the persons table has information on both married and unmarried persons, then birthdate is not something that is exactly-one-to-exactly-one, and the example is not relevant to the question at hand.

Marshall Received on Fri Mar 03 2006 - 17:40:26 CST