Re: circular relationships ok?

On 3 Mar 2006 15:40:26 -0800, "Marshall Spight" <marshall.spight_at_gmail.com> wrote:

>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.

     It is one-to-one to the person table, and it is relevant where such a piece of data should go, just as a piece of data that is 1-1 with the marriage table would go there (e.g. data of marriage).

Sincerely,

Gene Wirchenko Received on Sat Mar 04 2006 - 01:04:54 CET