Creating a foreign key relationship from a parent entity to a child entity

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:
  1. 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
  2. Select the parent entity, which has the primary key.
  3. 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.

Feedback