Home > Data Modeler Dialog Boxes > Relation Properties
This dialog box displays the properties of a relation, which is part of the Logical Model.
General
Name: Name of the relation.
Long Name: Long name for display purposes.
Cardinality
Source: Source entity for the relation.
Name on Source: Text describing the role of the source entity in the relation (for example, "has"). This text is displayed in the logical model diagram if you enable the Show Source/Target Name option for the Logical Model diagram in the Diagram user options.
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 relation 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.
Target: Target entity for the relation
Name on Target: Text describing the role of the target entity in the relation (for example, "any number of"). This text is displayed in the logical model diagram if you enable the Show Source/Target Name option for the Logical Model diagram in the Diagram user options.
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 relation 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.
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.)
Engineer To
Enables you to specify the relational models to which this relation should be propagated in forward engineering operations.
Engineer: Controls whether the relation 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.
Impact Analysis
Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.
Comments, Notes, Measurements, Change Requests, Responsible Parties, Documents, Summary