Relationship properties for a data model

Use the Properties view to modify the properties of a data model relationship.
General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Identifying Select to specify 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 Select to specify that the relationship is not an identifying relationship. A non-identifying relationship is one in which both entities are independent.
Enforced Select to specify that the relationship is not an implicit relationship. For DB2® UDB for Linux®, UNIX®, and Windows® or DB2 UDB 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, this option results in no foreign key clause generation.
Deferrable Specify whether constraint checking is deferred until the end of a transaction. This option is only available for databases that support deferred constraint checking.
Schema Shows the relational schema 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 Type a verb phrase that describes the relationship from the perspective of the child table. For example: RESUME "is owned by" EMPLOYEE.
Verb Phrase Type a verb phrase that describes the relationship from the perspective of the parent table. For example: EMPLOYEE "owns" RESUME.
Cardinality (Child) Specify 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) Specify 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) Use the grid to add, remove, or reorder 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 Select an action on the child table when an UPDATE action is taken on the parent table.
On Delete Select 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
Add or delete properties and edit their values.

Feedback