...
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 Teacher.Department contains the same data as the primary key SchoolDept.UID.
A tables table's unique identifier is its primary key, and where it occurs in another table, it is a foreign key.
...