Creating a foreign key relationship from a parent table or view to a child table

You can create a foreign key relationship from a parent table or view to a child table in a physical data model diagram.

About this task

To create a foreign key relationship:

Procedure

  1. Select a type of relationship in the palette. You can select the following types of relationships:
    Identifying
    In an identifying relationship, the existence of the child entity is dependent on the parent. For example, EMPLOYEE can have an identifying relationship with WORKCOMPLETED.
    Non-Identifying: Optional, Mandatory, or One-to-One
    Non-identifying relationships are relationships between two independent tables. For example, CUSTOMER can have a non-identifying relationship with INVOICE. You can specify whether these relationships are enforced (mandatory) or not enforced (optional). You can also specify that the relationship is a one-to-one relationship, in which case each row in one table is related to only one row in the other table.
    View
    This represents the relationship between a view and a table.
  2. Select the parent table that has the primary key, or select a view to create a view relationship.
  3. Drag to the child table. Depending on the type of relationship you are creating, a pop up window might open asking you to specify relationship options.

Results

The key is migrated from the parent table or view to the child table.

Feedback