Analysis › Develop the Data Model › Lesson Activity › Build the eGolf Services Data Model › Add Golfer and Scoring Record Entity Types

Add Golfer and Scoring Record Entity Types

To add the golfer and scoring record entity types, you must complete these steps:

• Add the Golfer
• Add the Scoring Record
• Move the entity types
• Create the relationship between the golfer and the scoring record

Follow these steps:

1. To add the Golfer and Scoring Record entity types, use the Add Entity Type icon on the tool palette and use the crosshair to click on the Golfers subject area.
2. In the Entity Type (new object) Properties dialog, type Golfer in the Type Name field and select OK.
3. Do the same to add Scoring Record.

   If you make a mistake, here are some tips to correct it:

   • If you mistyped the name of an entity type, double-click the entity type to open its properties panel and type the correct name.
   • If you placed the entity type in the wrong subject area, resize the destination subject are to ensure it is large enough to accept the new entity type, and drag and drop the entity type to the correct subject area.
   • To resize the subject area, select the subject area, and move the cursor across its boundaries until it turns into a double-sided arrow. Click-and-drag the boundary to the desired size. When moving an entity type from one subject area to another, the cursor changes to the following icon:

     

     to indicate you are changing the parentage of the entity type.

   • You can also delete the entity type by selecting it and clicking the Delete… icon on the Toolbar.
4. Resize the subject area and move the entity types as shown in the following illustration:

   

   To resize the subject area, follow these steps:

   1. Select the subject area
   2. Move the cursor across its boundaries until it turns into a double-sided arrow
   3. Click-and-drag the boundary to the desired size
5. To add the relationship between Golfer and Scoring Record:
   1. Select the Join… icon on the tool palette
   2. Select the Golfer entity type
   3. Select the Scoring Record entity type
6. Complete the Relationship Properties dialog as in this illustration and click OK:

   

   Note: You must type MAINTAINS and IS_MAINTAINED_BY in the fields.

   These settings create the following relationship between the GOLFER and SCORING RECORD:

   • Each GOLFER sometimes maintains one or more SCORING RECORD
   • Each SCORING RECORD always is maintained by one GOLFER

If you make a mistake, double-click the relationship to open the Relationship Properties dialog to make changes.

Your diagram should look similar to the following illustration: