| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: DB required to list multiple D.I.V.O.R.C.E.S. & Re-marriages
Thanks to ALL - merry thingy
-- d_at_ve @llison, Dundee, Scotland http://www.wedding-service.co.uk/ Allahu Akbar Allahu Akbar La Ilaha Ila Allah Wa Allahu Akbar Allahu Akbar Wa Lillahi Alhamd "James" <jraustin1_at_hotmail.com> wrote in message news:a6e74506.0112201353.b7d39_at_posting.google.com...Received on Sun Dec 23 2001 - 01:20:11 CST
> > DB required to list multiple D.I.V.O.R.C.E.S. & Re-marriages
> >
> > With many couple getting Divorced and re-married should I have multiple
> > cross referanced fields ?
> >
> > If a couple re-married the other couple is this M:N ? or 1:1 ?
>
> An oodb has the flexibility to represent the below situations. In XDb,
> a property can have 0, 1 or many values.
>
> Marriage1
> .Husand = John
> .Wife = Mary
> .Married = 1/1/00
>
> Marriage2
> .Husband = John
> .Husband = Mike
> .Married = 1/1/00
> .Divorced = 1/1/00
>
> Marriage3
> .Wife = John
> .Wife = Mike
> .Married = 1/1/00
> .Divorced = 1/1/00
>
> Marriage4
> .Husband = John
> .Wife
> ->Mary
> .Married = 1/1/00
> ->Jane
> .Married = 1/1/00
> .Divorced = 1/1/00
> .Married = 1/1/00
>
>
> www.xdb1.com
>
![]() |
![]() |