Database Answers Header The 18th. Hole at Pebble Beach
Data Model for Golf Tournaments
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

The FACTS define the Business Rules ...

1. What are the 'Things of Interest' in the Scope to be modelled ...

  • Golf Clubs
  • Players
  • Members
  • Tournaments
  • Tournament Contests.

    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.
    [ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search | Site Map ]

    © IceBreaker WebDesigns 2001