[UPHPU] Database relationship problem

[Webot Graphics]

I would think that it would be best to have a separate column for  
each. I am not an expert, but i have read a lot about normalization  
since I started the last thread. The reason why I would separate it  
is because each of those last names is going to be connected to  
another family name somewhere.

Father - James Billy /Bob Jones/
Mother -  Mary Contrary /Flower Petal/
Son - John Smith /Bob Flower/

As the first surname came from the father you want a connection there  
and since the second surname came from the mother you want a  
connection there. If both names are in one field, I think it would be  
hard for you to program the connections.

Justin Giboney
graphics at westernbotanicals.com



On Aug 17, 2006, at 8:31 AM, Smith, Jeff wrote:

> -----Original Message-----
> From: uphpu-bounces at uphpu.org [mailto:uphpu-bounces at uphpu.org] On  
> Behalf
> Of Scott Hill
> Sent: Wednesday, August 16, 2006 4:53 PM
> To: uphpu at uphpu.org
> Subject: [UPHPU] Database relationship problem
>
> 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.
>
> Person table
> ID
> Surname
> ....
>
> Given Name Table
> ID
> Name
>
> Person Names Table
> Person ID
> Given ID
>
> 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?
>
> --
> Scott Hill
>
> "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
>
> _______________________________
>
> I don't have a solution but I can add to the problem.  How would  
> you get
> the given name in the correct order.  You don't want confuse Billy Bob
> James Jones confused with James Billy Bob Jones.
>
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>