Anthony George I don't think we need this page anymore.
This page is for data modellers or application designersanyone using an ERD to define data structures. It explains the properties for relationships.
Overview
Relationships are part of ERDs; see see Understanding ERDs and Drawing ERDs for details.
Relationships are not listed in the repository. You can access relationship properties from an ERD. Click on the relationship arrow to open its properties. For example, the relationship arrow in the screenshot below is called has-teacher.
. They represent the connection between a primary key attribute in one table and an attribute in another table. For example, the relationship line in the screenshot below shows that the Teacher table includes an attribute called Department, and this contains the ame data as the SchoolDept table's unique identier (UID).
A tables unique identifier is its primary key, and where it occurs in another table, it is a foreign key.
To open relationship properties, in an ERD click on the relationship line. Relationships are not listed in the repository.
Most of the properties of a relationship are automatically set by the ERD, so are read-only. You can add details to the description.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Basic Settings
| Field | Description |
|---|---|
| Name | Enter the name for this relationship. Relationships between the same two tables must have the unique names. |
| Stream A | The name of the source table for the relationship. |
| Stream Attribute A | The source attribute. |
| Stream B | The name of the destination table for the relationship. |
| Stream Attribute B | The destination attribute. |
...