Database Answers The 18th. Hole at Pebble Beach, California.
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Models for Golf Course Specifications   
We would be glad to have your comments.

'Things of Interest'

How they are Related

Conceptual Data Model for Golf Course Specifications
The Method
The Method consists of three simple Rules :-
Rule 1. Identify the 'Things of Interest'.
Rule 2. Establish how they are related.
Rule 3. Define what else we know about them.

Applying the Method

Step 1. Identify the 'Things of Interest'.
Things of Interest are Courses and Holes.

Step 2. Establish how they are related.
The Rules that define their relationship are :
Rule 1. A Golf Course contains one or many Holes.
Rule 2. A Hole is always associated with a specific Course.

At this point, we can create the Conceptual Model, which we show on the left.
Then we think about the Logical Model and realise that there is a One-to-Many Relationship between Courses and Holes.
The Logical Model.
Now we can create the Logical Model showing the Key fields, which we show on the right.

Step 3. Define what other Facts we know about them.
Fact 1. We know that a Course will always have a name.
Fact 2. Holes always have a Par 'Par' which Wikipedia defines Par as the number of strokes that a good golfer should require to complete a hole.
Fact 3. A Hole can have a name as well as a number.
For example 'Pink Dogwood' is the second Hole at the Augusta Masters Course.
Fact 4. A Hole is always identified by a specific number, usually from 1 to 18.
Logical Model showing Keys only

Logical Data Model with Keys only for Golf Course Specifications

Logical Model

Logical Data Model for Golf Course Specifications

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
April 14th. 2016

© DataBase Answers Ltd. 2016
About Us Contact Us