Previous Topic: Add Golfer and Scoring Record Entity TypesNext Topic: Review the Data Model Using the Data Model List


Add Attributes to Golfer and Scoring Record

Follow these steps:

  1. To add attributes more efficiently, turn the Multiple Adds feature on. To do so, on the Menu Bar select Model, Settings, Multiple Adds.
  2. To add the Golfer attributes, select the Golfer entity type, click the Attributes Add Attributes to Golfer and Scoring Record icon on the Tool Bar bringing up the Attribute List diagram, and select the Add…Attribute ViewAdd Attributes to Golfer and Scoring Record icon on the Tool Bar.

    Note: The Add Attribute View icon and the Attributes icon are the same.

  3. In the (new object) Properties dialog, enter the following information for each attribute.

    Note: The (new object) Properties dialog remains open after you click OK after adding each attribute because Multiple Adds is turned on.

    You should be able to see each attribute added in the panel in the background. After adding the last attribute for Golfer click Cancel.

Attribute Name

Category

Domain

Length

Decimal Places

Optional

Case Sensitive

Varying Length

Userid

Basic

Text

8

N/A

 

 

 

Password

Basic

Text

8

N/A

 

Add Attributes to Golfer and Scoring Record

 

First Name

Basic

Text

30

N/A

 

Add Attributes to Golfer and Scoring Record

 

Last Name

Basic

Text

30

N/A

 

Add Attributes to Golfer and Scoring Record

 

Handicap Index

Basic

Number

4

1

Add Attributes to Golfer and Scoring Record

N/A

N/A

Email Address

Basic

Text

100

N/A

Add Attributes to Golfer and Scoring Record

Add Attributes to Golfer and Scoring Record

Add Attributes to Golfer and Scoring Record

  1. To close the Attribute List Diagram listing the attributes for Golfer, select the close button Add Attributes to Golfer and Scoring Record in the upper right hand corner of the Toolset, diagram at the end of the Menu Bar (not the one which may be above it which closes the toolset entirely).

    If you make a mistake, select the entity type, select the Attributes icon on the Menu Bar, and double-click the attribute in the Attribute List Diagram to open the properties dialog for the attribute. To delete an attribute, select the attribute and select the Delete icon on the Menu Bar.

  2. Add the following attributes to Scoring Record.

Attribute Name

Category

Domain

Length

Decimal Places

Optional

Case Sensitive

Varying Length

Date

Basic

Date

N/A

N/A

 

N/A

N/A

Time

Basic

Time

N/A

N/A

 

N/A

N/A

Adjusted Gross Score

Basic

Number

3

0

 

N/A

N/A

Course Rating

Basic

Number

3

1

 

N/A

N/A

Course Slope Rating

Basic

Number

3

0

 

N/A

N/A

Note

Basic

Text

100

N/A

Add Attributes to Golfer and Scoring Record

Add Attributes to Golfer and Scoring Record

Add Attributes to Golfer and Scoring Record

  1. Two of the Scoring Records attributes names are longer than 15 characters, and can be a problem when targeting JDBC as we will do for our Web server. In the list of attributes for Scoring Record:
    1. Double-click ADJUSTED_GROSS_SCORE
    2. Uncheck the 'Set TD name to the attribute name checkbox'
    3. Change the TD Name to ADJ_GROSS_SCORE
    4. Do the same for COURSE_SLOPE_RATING