[UPHPU] Database relationship problem
llihttocs at gmail.com
Wed Aug 16 16:53:18 MDT 2006
After following the last database thread, it is obvious that there are many
who have lots of experience with database design. So, I have a question
about a relationship problem in a genealogy database. The problem is given
names. It is very common for people to have one or two given names.
However, there are many with more than two. I have seen some genealogy
databases with 10 given name columns to accomodate this. This is, of
course, a horrible violation of normalization rules. You could create a
given name table with a link to the person table but this would create a lot
of redundancy. In other words, a lot of records with the same common
name. So, it seems to me that it's best to have a many to many relationship
and create a junction table.
Given Name Table
Person Names Table
My question is what would the SQL look like to retrieve the person with all
of their names? Or is there a better way to represent this relationship?
"May you solve interesting problems" - Author Unknown
"A fanatic is one who can't change his mind and won't change the subject." -
Sir Winston Churchill
More information about the UPHPU