Chapter 4 Building Conceptual Data Models

Defining a code option for relationships

You can define the following code option for relationships:

Option Result when selected Result when cleared
Unique code Each relationship has a unique code Different relationships can have the same code

If you do not select Unique Code, two relationships can have the same code. In this case, you differentiate the relationships by the entities they link.

Error message

The following error message appears when the option you choose is incompatible with the current CDM:

Error message Solution
Unique Code option could not be selected because at least two relationships have the same code: relationship_code. Change the code of one relationship

Steps To define a code option for relationships:

  1. Select Tools→Model Options.

    The Model Options dialog box opens to the Model Settings page.
  2. Select the Unique Code check box in the Relationship groupbox to require a unique code for each relationship.

    or

    Clear the Unique Code check box in the Relationship groupbox to allow more than one relationship to have the same code.
  3. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.