Relationships in the Logical Model

This section contains the following topics:

Relationships in the Logical Model

Identifying Relationships in a Logical Model

Add an Identifying Relationship

Add Multiple Consecutive Identifying Relationships

Non-Identifying Relationships in the Logical Model

Optional Non-Identifying Relationships in the Logical Model

Mandatory Non-Identifying Relationships in the Logical Model

Add a Non-Identifying Relationship

Add Multiple Consecutive Non-Identifying Relationships

Subtype Relationships in the Logical Model

Add a Complete Subtype Relationship

Add an Incomplete Subtype Relationship

Add an Inclusive Subtype Relationship

Add an Exclusive Subtype Relationship

Assign a Discriminator to a Subtype Relationship

Many-to-Many Relationships in the Logical Model

Add a Many-to-Many Relationship

Add Multiple Consecutive Many-to-Many Relationships

Resolve a Many-to-Many Relationship in a Logical Model

Recursive Relationships

Add a Hierarchical Recursive Relationship

Add a Network Recursive Relationship

Relationship Tools in the Logical Model

Add a New Relationship in a Logical Model

Change the Relationship Type

Display a Relationship in the Logical Model Only

Highlighting Relationship Lines

Parent Child Edit Selector

Navigate a Model Using Relationships

Delete a Relationship

Verb Phrases for Relationships

Add a Two-Part Verb Phrase

View Verb Phrases in a Logical Model

Relationship Cardinality

Set Relationship Cardinality

View Cardinality Symbols in a Logical Model

Relationship Null Options

Set the Default Null Option for a Non-Identifying Relationship

Change the Null Option for a Non-Identifying Relationship

Attribute Rolenames

Assign a Rolename to an Attribute

Delete a Rolename

Enter a Definition for a Relationship

Referential Integrity Trigger Actions

Relationship Editor - RI (Referential Integrity) Actions Tab Options

Assign Relationship UDP Values in the Logical Model

Foreign Key Migration

Unifying Relationships

Control Migrating Foreign Key Unification

Alternate Key Migration

Migrate an Alternate Key as a Foreign Key