Chapter 4 Building Conceptual Data Models


Designating an identifier

You designate an identifier from the Identifiers page of the entity property sheet.

For information on how to display identifiers in an entity symbol, see section Modifying the entity display preferences.

You can also create an identifier from the list of entity attributes: click the Attributes tab in the entity property sheet, select one or more attributes to include into the identifier and click the Create Identifier tool.

Steps To designate an identifier:

  1. Double-click an entity in the diagram to display the entity property sheet.
  2. Click the Identifiers tab to display the corresponding page.

    It lists identifiers defined for the entity.
  3. Click a blank line in the list.

    or

    Click the Add a Row tool.

    An arrow appears at the beginning of the line.
  4. Type an identifier name and code.
  5. Click Apply.

    The constraint name and code are committed.
  6. Double-click the new identifier name to display the identifier property sheet.
  7. Click the Attributes tab to display the corresponding page.

    It lists all entity attributes defined for the identifier. At identifier creation, the list is empty.
  8. Click the Add Attributes tool.


    A list of entity attributes defined for the entity appears.
  9. Select check boxes for one or more entity attributes that you want to designate as an identifier.
  10. Click OK in each of the dialog boxes.

 


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