Chapter 3 Building Conceptual Data Models

Defining a code option for relationships

The following model option allows you to control naming restraints for relationships:

Option When selected Result when cleared
Unique code Each relationship must have a unique code. Multiple relationships can have the same code.

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

Error message

The following error message is displayed 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 the Unique Code model option for relationships:

  1. Select Tools→Model Options to open the Model Options dialog box:
  2. Select or clear the Unique Code check box in the Relationship groupbox, and then click OK to return to the model.

 

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