'Things of Interest'
How they are Related
|
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 Model
|
Printer-friendly version
