Timeline for Model a family tree database in Access 2007
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 19, 2012 at 5:23 | comment | added | Cindy Jayakumar | I'm going to implement in Access the schema as described above, and see if it behaves the way I want it to. | |
| Apr 12, 2012 at 16:02 | comment | added | Cindy Jayakumar | A very interesting approach in that blog post - I like the idea of the "marriage" being intransitive. Flint is married to Rahab, and cohabiting with Cullen-Fer, but that does not mean that Rahab is married to Cullen-Fer, or has any kind of relationship with her at all. I'm thinking a separate MARRIAGE table linked to FAMILY would be more appropriate. | |
| Apr 12, 2012 at 9:49 | comment | added | ypercubeᵀᴹ | Here's a funny reading to get some ideas: Gay marriage: the database engineering perspective | |
| Apr 12, 2012 at 9:47 | comment | added | Cindy Jayakumar | Yes, I should have said "potentially 2 or more", I'll edit the question now. The "parent" and "marriage" relationships would have been my next task, as I would need to differentiate between the different roles within a "marriage" (the Sim could be husband/wife/concubine/mistress) and also the type of marriage (arranged/love/affair) etc. | |
| Apr 12, 2012 at 9:39 | comment | added | ypercubeᵀᴹ |
Oh, I didn't see the SIM_FAMILY table the first time. It looks fine. (I can see a few issues like that a Family can have many Sims with the same role. And I assume a family can have many daughters but not many fathers, so it would be a complex constraint.)
|
|
| Apr 12, 2012 at 9:29 | comment | added | ypercubeᵀᴹ | Now if you try to put parent and marriage relationship, too, it's a great exercice! | |
| Apr 12, 2012 at 9:28 | comment | added | ypercubeᵀᴹ |
Then it's a N:M relationship. It's not strictly 2:M.
|
|
| Apr 12, 2012 at 9:20 | comment | added | Cindy Jayakumar | I have written down all the relationships, and created the ERD for it, with all the possible tables and FKs. I put the "at least 2" families there to illustrate the potential for the N:M relationship between SIM and FAMILY. If the SIM does not marry, he/she only belongs to the father's family, which would be a straightfoward 1:M, but seeing as most SIMs do marry, they will belong at least to their father's family, the new family created from their first marriage, and any other families formed from any subsequent marriages. | |
| Apr 12, 2012 at 8:01 | history | answered | ypercubeᵀᴹ | CC BY-SA 3.0 |