Entity Relationship Modelling Problem for a Genealogy RDB

I've managed to model the following entities (events) for a genealogy database;

INDIVIDUAL -> 1:N -> BIRTH     <- N:1 <- LOCATION1 (civil)
INDIVIDUAL -> 1:N -> BAPTISMAL <- N:1 <- LOCATION2 (religious)
INDIVIDUAL -> 1:N -> DEATH     <- N:1 <- LOCATION1
INDIVIDUAL -> 1:N -> FUNERAL   <- N:1 <- LOCATION2

The entity MARIAGE or UNION has me stumped.

1st - depending on the structure it may require a unique identifier!
2nd - 2 foreign keys mapped to INDIVIDUAL are needed to establish the union.
3rd - This blessed event may be certified by the state and/or sanctified
      by the church. How do you establish the right relationship to the
      proper location where the event(s) took place?
4th - individuals have been known to get married, get divorced and get
      married to each other again. Non-unique entries on foreign keys!

I've tried a few kludges to no avail.

How would you model this? Your thoughts on this matter would be appreciated.

Thanks

Guy Received on Sun Oct 28 2001 - 07:59:31 CET