On 24 Feb 2011, at 3:18pm, Philip Graham Willoughby wrote: > On 24 Feb 2011, at 14:07, Simon Slavin wrote: > >> A more flexible way to lay out genealogy databases is as follows: >> >> Person: id, name, sex, dob >> >> Relationship: id1, id2, connection >> >> So you end up with things like >> >> 1, 17, grandparent >> 1, 2, parent >> 1, 3, spouse > > Ewww that's nasty; I don't like the duplication of data which is implied by > other data, because it is easy to construct an inconsistent situation. Either > grandparent relationships are derived from parent relationships (in which > case why not make a view to do that) or they are entered separately and there > is scope for error.
Oops. You're dead right: grandparent relationships should be derived. I wasn't thinking Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
