Arabella

111 reputation

bio	website
	location	South Africa
	age	24
visits	member for	1 year, 1 month
	seen	Jan 16 at 5:16
stats	profile views	13

I studied 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.

	111 reputation	bio	website		visits	member for	1 year, 1 month
5 badges		location	South Africa		seen	Jan 16 at 5:16

summary answers questions tags badges favorites bounties reputation activity

24 Actions

suggestions reviews revisions comments badges posts accepts all

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.