Relationship properties for a data model

Use the Properties view to modify the properties of a data model relationship.
General page
Property Description
Name Specifies a name for the object.
Label Type a label. This label is displayed in visual diagrams.
Identifying Specifies that the relationship is an identifying relationship. An identifying relationship is one in which one of the child entities is also a dependent entity.
Non-Identifying Specifies that the relationship is not an identifying relationship. A non-identifying relationship is one in which both entities are independent.
Enforced Specifies that the relationship is not an implicit relationship. For DB2® for Linux®, UNIX®, and Windows® or DB2 for iSeries® that support informational constraints, this option results in the generation of a foreign key clause with ENFORCED = FALSE. For databases that do not support information constraints, the foreign key clauses are not generated.
Deferrable Specifies whether constraint checking is deferred until the end of a transaction. This option is only available for databases that support deferred constraint checking.
Schema or Owner Shows the relational schema or the entity under which this object was created.
Details page
Property Description
Table (Child) Shows the child table for this relationship.
Table (Parent) Shows the parent table for this relationship.
Inverse Verb Phrase Specifies a verb phrase that describes the relationship from the perspective of the child table. For example: RESUME "is owned by" EMPLOYEE.
Verb Phrase Specifies a verb phrase that describes the relationship from the perspective of the parent table. For example: EMPLOYEE "owns" RESUME.
Cardinality (Child) Specifies a cardinality value for the child table. You can select one of the following options:
  • 0..1: Zero or one
  • 1: One
  • *: Many
  • 1..*: One to Many
Cardinality (Parent) Specifies a cardinality value for the parent table. The values that are available in the list change depending on whether the relationship is an identifying or a non-identifying relationship. You can select:
  • 1 (Mandatory): One. Designates the relationship as a mandatory relationship.
  • 0 (Optional): Zero or One. This option is only available if the relationship is a non-identifying relationship. Designates the relationship as an optional relationship.
Key columns (Child) Modifies foreign key columns for the child table.
Unique constraint or Index (Parent) Select a unique constraint or index for the parent table.
Referential Integrity page
Property Description
On Update Specifies an action on the child table when an UPDATE action is taken on the parent table.
On Delete Specifies an action on the child table when a DELETE action is taken on the parent table.
Documentation page
Type information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback