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