116 reputation
5
bio website arabellasmusings.wordpress.co…
location South Africa
age 25
visits member for 2 years, 4 months
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.


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.
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
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
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
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.
Apr
12
comment Model a family tree database in Access 2007
I'm sorry for not being clear on that point, a SIM is equivalent to PERSON, so it would have all the normal attributes such as date of birth, hair colour, eye colour, sex etc.
Apr
12
comment Model a family tree database in Access 2007
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
11
comment How do I design a database for continents, countries, regions, cities and POIs?
I think your question would be better answered over at gis.stackexchange.com, at least you can get answers there specifically from GIS people who have implemented geodatabases in different ways.