Relation Properties

This dialog box displays the properties of a relationship, which is part of the Logical Model.

General

Name: Name of the relationship.

Use Surrogate Keys: Controls whether surrogate keys are used to ensure uniqueness by adding a level prefix to the members.

Source Cardinality

Source: Source entity for the relationship.

Source Key:

Name on Source: Text describing the role of the source entity in the relationship (for example, "has"). This text is displayed in the logical model diagram if you select Show, then Labels from the diagram context menu.

Source Entity Synonym: Synonym for the source entity.

Source to Target Cardinality: Cardinality of source records to target records with the same key value: * for many, or 1 for one.

Source Optional: Controls whether the source entity in the relationship must contain one or more instances. If this option is enabled, there can be zero source instances; if this option is disabled, one or more source instances are required.

Transferable:

Target Cardinality

Target: Target entity for the relationship.

Target Key:

Name on Target: Text describing the role of the target entity in the relationship (for example, "any number of"). This text is displayed in the logical model diagram if you select Show, then Labels from the diagram context menu.

Target Entity Synonym: Synonym for the target entity.

Target to Source Cardinality: Cardinality of target records to source records with the same key value: * for many, or 1 for one

Target Optional: Controls whether the target entity in the relationship must contain one or more instances. If this option is enabled, there can be zero target instances; if this option is disabled, one or more target instances are required.

Transferable:

Dominant Role: Entity with the dominant role.

Identifying: Controls whether this is an identifying relationship. When there is an identifying relationship between a parent entity and a child entity, when the relational model is generated, the following occurs in the child table: the foreign key to the parent becomes part of the primary key of the child. (In non-identifying relationships, the foreign key to the parent table is just another column in the child table and is not part of the primary key.)

Delete Rule: Action to take automatically for the child end of the relationship; used in engineering to the relational model. When a row in the child table is deleted and rows with that value exist in the parent table, NO ACTION performs no action on these rows; CASCADE deletes these rows; SET NULL sets null all columns in those rows that can be set to a null value; RESTRICT prevents those rows from being deleted.

Attributes

Lets you define any attributes of the relationship.

Name: Name of the attribute.

Datatype: Data type of the attribute.

Mandatory:

Engineer To

Enables you to specify the relational models to which this relationship should be propagated in forward engineering operations.

Engineer: Controls whether the relationship is propagated to the specified Relational Design (model) during forward engineering operations.

Comments in RDBMS

Comment text to be included in database objects that are generated based on this modeling object.

Comments, Notes, Impact Analysis, Measurements, Change Requests, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.