116 reputation
5
bio website arabellasmusings.wordpress.co…
location South Africa
age 25
visits member for 2 years
seen Nov 13 '13 at 8:47

I have a Bachelor of Science in Applied Geoinformatics, with my main areas of study being Geography and Environmental Studies, GIS, Computer Science and Information Systems. I have always had a passion for computers and geography, so studying and working in the GIS field has given me the best of both worlds.

My questions/answers will be written in South African (UK) English - please do not "correct" my spelling.


Aug
21
awarded  Supporter
Jun
18
revised Implementing a family database using Access 2010
clarified question
Jun
14
comment Implementing a family database using Access 2010
@NeilMcGuigan excellent link...and an issue I will need to handle as well (quite a few of my Sims have/had relationships and/or children with siblings/cousins etc). Family Tree Maker does allow for this though, so if Flint marries his sister Ferial, in their relationship tab she is listed under his siblings as "Wife". The programme doesn't even give a warning though, something along the lines of "The spouse is a sibling. Add relationship anyway?" Anyway.
Jun
13
asked Implementing a family database using Access 2010
Apr
19
awarded  Autobiographer
Apr
19
awarded  Commentator
Apr
19
comment Model a family tree database in Access 2007
I'm going to implement in Access the schema as described above, and see if it behaves the way I want it to.
Apr
16
revised Model a family tree database in Access 2007
improved formatting
Apr
16
revised Model a family tree database in Access 2007
improved formatting
Apr
16
comment Model a family tree database in Access 2007
@miracle173 I've edited my question with the revised table structure and a clear example.
Apr
16
revised Model a family tree database in Access 2007
revised example and table structure
Apr
13
revised Model a family tree database in Access 2007
improved formatting
Apr
13
comment Model a family tree database in Access 2007
2. I realise my description is a bit convoluted. The "founder" is a special instance which only occurs in the 1st and 2nd generations, all of which take place in Era 1. There are 5 founders in Generation 1, 1 for each of the 5 tribes. The Clan founders are all the males in Generation 2 (sons of the founders), regardless of who their mothers are. I should add a "tribe_founder_id" to TRIBE, as with CLAN.
Apr
13
comment Model a family tree database in Access 2007
1. Yes. The sim_role field was there to indicate the status of the Sim in relation to the family, but it does not make sense, because each Sim will have a different relation with each family member, and I don't want to be rigid in purely defining a Sim's role in relation to its parents. I do agree with you that once the fam_dad_id and fam_mom_id have been linked to a FAMILY, each additional SIM linked to that fam_id is automatically a son/daughter depending on their sex_id.
Apr
13
comment Model a family tree database in Access 2007
The head of each family is always a male i.e. If Caleb has 5 sons, at least 5 new families will be formed once each son has been assigned a female. I've been defining a FAMILY as when a male has a child with a female (whether the relationship between the two is a marriage/affair/concubinage/friendship/whatever), but I realise this is insufficient, as I might have a situation where the male's first wife cannot have children. Even if he has subsequent children with additional wives, it doesn't mean that he and his first wife don't constitute a family.
Apr
12
comment Model a family tree database in Access 2007
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
awarded  Student
Apr
12
awarded  Editor
Apr
12
revised Model a family tree database in Access 2007
clarified question, removed unnecessary parts
Apr
12
comment Model a family tree database in Access 2007
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.