Re: baseball league db design

From: Karel Miklav <karel_at_lovetemple.adbloccker.net>
Date: Sat, 24 Jan 2004 12:01:33 +0100
Message-ID: <yfsQb.1942$%x4.328295@news.siol.net>

John O'Conner wrote:
> One other thing...many of the participants share the same address. For
> example, parents, siblings in the same league, etc. Does it seem
> reasonable to store addresses separately in an Address table? Then
> each participant would have a foreign key to an Address.

It seems like the only right way from the point of DB design, but there is a slight problem with input; some people will enter street name as '4th of July', some 'Fourth of July Street'. If you're prepared to handle this...

Regards,
Karel Miklav Received on Sat Jan 24 2004 - 05:01:33 CST