In relational databases, a link between two entities that’s based on attributes of the entities. For example, the Department and Employee entities can have a relationship based on the deptID attribute as a foreign key in Employee, and as the primary key in Department. This relationship would make it possible to find the employees for a given department.