|
|
|
Relationships are important because the type of relationship determines how a primary key of the parent entity or table migrates to the child entity or table as a foreign key. There are two basic types of relationships:
An identifying relationship is represented by a solid line and through it the primary key of the parent migrates to the primary key area of the child entity or table.
A non-identifying relationship is represented by a dashed line and through it the primary key of the parent migrates to the non-key area of the child entity or table.
In an identifying relationship, the foreign key migrates above the line and becomes part of the primary key of the child entity (see Foreign Key for more information). In a non-identifying relationship, the foreign key migrates below the line and becomes a non-key attribute in the child entity. A dashed line represents a non-identifying relationship.
Note: If you want a non-key to migrate instead of the primary key, you can use the alternate key migration option. For more information, see the online help.
| Copyright © 2012 CA. All rights reserved. |
|