I agree with Tom, it's better to keep every single field separate and
representing one thing only. I like the idea of separate years for
the NHL and WHA because for argument sake, it's easier to sort data
for the players from each of those leagues, let alone those who
played in both leagues.

Eric

--- In hockey-databank@yahoogroups.com, Tangotiger <tangotiger@...>
wrote:
>
> On a data design issue, every single field should
> represent one and only one thing. Merging data into
> one field is not a good idea.
>
> Tom
>
>
> --- dsreyn <dreynolds@...> wrote:
>
> > The Master table currently contains four fields
> > (firstNHL, lastNHL,
> > firstWHA, lastWHA) that give the years a player was
> > active in the NHL
> > and WHA. I'm considering replacing these with one
> > pair of fields to
> > indicate the span of years for which a player has
> > data in the Scoring
> > and Goalies tables. In addition to combining the
> > NHL and WHA years,
> > this would also include the three older leagues
> > (NHA, PCHA, WCHL).
> >
> > I don't see this as a major change, but I thought
> > I'd mention this
> > before going ahead. If this will cause a serious
> > inconvenience for
> > anyone, I could be persuaded to leave it alone.
> >
> > Doug
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > (Yahoo! ID required)
> >
> > mailto:hockey-databank-fullfeatured@yahoogroups.com
> >
> >
> >
>
>
> ---------------------------------------------
> Tim Raines, Hall of Fame 2008
> http://www.raines30.com/
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------
>
>
>
______________________________________________________________________
______________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>