Re: design

On Tue, 30 Jan 2001 11:35:21 -0500, Jeff <jeff4e@rochester.rr.com> wrote:
>I have a design question.  Lets say we want to keep track of users and
>their respective snail mail addresses.  Each user can have up to 4
>different mailing address.  Is it better to have all this information in
>one table. Or is it better to have a user table and an address table,
>and have the user id as a foreign key in the address table?
>
>Thanks!
>
>Jeff
>


The second option sounds much better to me.
Imagine trying to find out how many addresses each user has:

With everything in one table... tough one.
With all addresses in their own table and keyed by user id... simple.

I am sure you can find other reasons too.

Lee Harr
missive@hotmail.com