Re: baseball league db design

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 - 12:01:33 CET