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
- 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.
- Select the parent table that
has the primary key, or select a view
to create a view relationship.
- 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.