Previous Topic: Examine the Consistency Check ReportNext Topic: Perform Another Consistency Check

Analysis › Confirm the Process and Data Model › Lesson Activity › Correct the Problems

Correct the Problems

Follow these steps:

  1. Close the Consistency Check Report, but not the model.
  2. In the data model, double click the GOLFER entity type.
  3. In the Entity Type GOLFER Properties dialog, enter 75 for the Average Expected Number of Occurrences and 100 for the Maximum, and click OK.
  4. While the GOLFER entity type still has focus, select the Identifiers Correct the Problems icon on the Tool Bar.
  5. In the Identifiers for GOLFER dialog, select USERID from the Selection List, and select the Add button.
  6. In the (new object) Properties dialog, type golferid in the Identifier: entry field and click OK. If you have multiple adds turned on, select Cancel to close the (new object) Properties dialog. The Identifiers for GOLFER dialog should now look like the following illustration:

    Correct the Problems

    If you added more than one primary identifier, select the secondary identifier in the upper panel, unselect any selected items in the Selection List by selecting them again, and click Delete. If you mistyped the name of the identifier, select the identifier in the upper panel; unselect selected items in the Selection List by selecting them again, and select Properties button.

  7. Click Close to exit the Identifiers for GOLFER dialog.
  8. Repeat these steps for the SCORING RECORD entity type. The minimum, average, and maximum expected number of occurrences should be 0, 375, and 1000, respectively. The identifier consists of the attributes DATE and TIME, and the relationship IS MAINTAINED BY GOLFER. Select all three as in the following example, and click Add. Name the identifier scoreid.

    Correct the Problems

Record the cardinality and optionality of the relationship memberships.

Follow these steps:

  1. Double click the relationship line in the data model.
  2. In the Relationship Properties dialog, click Source Properties.
  3. In the Source Properties of MAINTAINS dialog, type 99 for the percentage of time, 1 for at least, 5 for on average, and 40 for at most.
  4. Click OK.
  5. Click Destination Properties to review the Destination Properties.
  6. Cancel out of the Destination Properties of IS MAINTAINED BY dialog, and click OK on the Relationship Properties dialog.