Previous Topic: Examples of RelationshipsNext Topic: Entity Subtypes


eGolf Services Relationship Cardinality and Optionality

A golfer needs at least five and preferably 20 scoring records to determine their handicap index. Therefore, a golfer maintains one or more scoring records. In addition, a golfer has to register first before logging in to use the system. Therefore, a golfer can exist, even if it is for only a short period, without any scoring records. From the point of view of the golfer, then, Each Golfer sometimes maintains one or more Scoring Records.

Scoring records are always for one golfer, so from the point of view of the scoring record, one Golfer always maintains Each Scoring Record. Our data model now looks like the following example:

eGolf Services Relationships