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


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
12
asked Model a family tree database in Access 2007
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.