Logical Modeling › Attributes › Add an Attribute to an Entity Using the Attribute Editor

Add an Attribute to an Entity Using the Attribute Editor

You can add an attribute to an entity in a logical model using the Attribute Editor.

To add an attribute to an entity using the Attribute Editor

1. Right-click the entity on the diagram to which you want to add an attribute and click Attribute Properties.

   The Attribute Editor opens.

2. Click New on the toolbar.

   A new attribute is displayed at the bottom of the attribute list in the Navigation Grid with default values.

3. Work with the following options in the Navigation Grid to assign values to the new attribute:

   Name

   Displays the attribute name. You can change the attribute name in this field.

   Parent Domain

   Displays the parent domain associated with the attribute. You can change the parent domain or open the Domain Editor to create a new one using the drop-down.

   Logical Data Type

   Specifies the logical data type for the attribute. You can change the data type using the drop-down. The drop-down list contains the data types related to the current domain.

   Primary Key

   Specifies whether to include the attribute in the primary key. Select this check box if you want to include the selected attribute in the primary key. Clear this check box if you want the attribute to be a non-key attribute.

   Logical Only

   Specifies whether the attribute should only appear in the logical model. Select this check box if you want the selected attribute to appear in the logical model only. Clear this check box if you want the selected attribute to have a corresponding column in the physical model.

   Note: If you are working with a logical-only model and select this check box, when you derive a new physical-only model, the selected attributes do not appear in the new model.

4. Click Close.

   The attribute is added to the entity and the Attribute Editor closes.

Note: You can click the up or down arrows in the toolbar to reposition the new attribute in the Navigation Grid.

More information:

Attributes

Define General Properties for an Attribute