databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Data Model Example

Golf Clubs and Membership Handicaps Scenario

The following data model is designed to hold information relating Members of a Golf Club and hold information relating to Members, Courses, Golf Rounds and Handicaps. For this scenario we need to define the following facts:

These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.

The draft facts have been defined as:

The Entities required should include:

  • Members
  • Courses
  • Course Hole Details (Information relating to a Hole at a Golf Course)
  • Golf Rounds (Rounds played by Members)
  • Player Handicaps

The Entities are related as follows:

  • One Member (Player) can play Many Golf Rounds
  • One Player can have Many Handicap Reports (Date Dependant)
  • One Golf Course can have Many Golf Holes (including Yardage and Par information)
  • One Golf Course can provide Many Golf Rounds

The design allows a Member (Player) to submit many Golf Round reports from differing Golf Courses, detailing scores made. This score information will go towards the Players Golfing Handicap.

When asking questions of the database we may need to know:

  1. How many Members (Golf Players) belong to the Golf Club?
  2. What score did a particular Member make when playing at a particular Golf Course?
  3. What is the Players current Golf Handicap?

The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner.

To view the model please go to: Relationships for Golf Matches Data Model

Please download the data model relating to Relationships for For Golf Matches which is contained in the zipped up Microsoft Word document.