Re: DB required to list multiple D.I.V.O.R.C.E.S. & Re-marriages
From: James <jraustin1_at_hotmail.com>
Date: 20 Dec 2001 13:53:30 -0800
Message-ID: <a6e74506.0112201353.b7d39_at_posting.google.com>
Date: 20 Dec 2001 13:53:30 -0800
Message-ID: <a6e74506.0112201353.b7d39_at_posting.google.com>
> 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 Received on Thu Dec 20 2001 - 22:53:30 CET