Re: Database design for a little soccer league

VTR250 wrote:

> If a team member moves from one team to another (ie. his/her parents
> sign the child up next year, but decide to go to a different team -
> also based near to where they live) will you just update the players
> table?
>
> If you did, the events table would record past goals as having been
> scored by the new team. If the match table records the full-time score
> (a possible optimisation) then there will be an inconsistency.
> Perhaps you will have to create a new player record and lose the
> player history. Ugh! Alternatively players cannot change to another
> team once signed up... or you need to extend the model a little bit so
> it includes the players history.

Yeah, we never even got to the bit about understanding the business model. I tend to assume it's understood that I can't guess what fact types the database must represent.

-- 
Roy