Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page is for anyone using an ERD to define a data structuresstructure. It explains the properties for relationships. 

...

Relationships are part of ERDs; see Understanding ERDs and Drawing ERDs. 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 .Department contains the ame same data as the SchoolDept table's unique identier (UID)primary key SchoolDept.UID.

A tables unique identifier is its primary key, and where it occurs in another table, it is a foreign key.

Image RemovedImage Added

To open relationship properties, in an ERD click on the relationship line. Relationships are not listed in the repository. 

...