Data Model for Golf Tournaments
The FACTS define the Business Rules ...
1. What are the 'Things of Interest' in the Scope to be modelled ...
2. How are these 'Things of Interest' related ? ...
GOLF CLUBS can have many MEMBERS.
A GOLF CLUB can have one or many MEMBERSHIP LEVELS.
GOLF CLUBS can host many TOURNAMENTS.
Many TOURNAMENTS occur every year.
PLAYERS can participate in zero or many TOURNAMENTS.
A PLAYER can be a MEMBER in one or many GOLF CLUBS, between specific Dates.
TOURNAMENT can have many PARTICIPANTS.
A TOURNAMENT can have zero or many CONTESTS, such as Longest Drive, Nearest Hole, etc..
A PARTICIPANT can achieve zero or many CONTESTS in a TOURNAMENT.
3. What do we know about the 'Things of Interest' ? ...
A GOLF CLUB is identified by a unique Code, and has a Name, Address and Other Details.
A PLAYER is identified by a unique ID, and has a Name, Address and Other Details.
A TOURNAMENT is identified by a unique Code, and has a Name, Sponsor, Start Date and End Date.