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:
The Entities are related as follows:
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:
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.