You can create a foreign key relationship from a parent entity
to a child parent entity in a logical data model diagram.
To create a foreign key relationship:
- Select a type of relationship in the palette. You can
select the following types of relationships:
- Identifying
- Non-Identifying Optional
- Non-Identifying Mandatory
- Non-Identifying One-to-One
- Many-to-Many
- Select the parent entity, which has the primary key.
- Drag to the child entity. Depending on the type
of relationship you are creating, a pop up window might open asking you to
specify relationship options.
The key is migrated from the parent entity to the child entity.