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