A **relationship** is an association between several entities.

A **relationship set** is a set of relationships of the same type.

**Formally** it is a mathematical relation on (possibly
non-distinct) sets.

If are entity sets, then a relationship set R
is a **subset** of

where is a relationship.

For example, consider the two entity sets *customer* and *account*.
(Fig. 2.1 in the text).
We define the relationship *CustAcct* to denote the association
between customers and their accounts.
This is a **binary** relationship set (see Figure 2.2 in the text).

Going back to our formal definition, the relationship set *CustAcct*
is a subset of all the possible customer and account pairings.

This is a binary relationship. Occasionally there are relationships involving more than two entity sets.

The **role** of an entity is the function it plays in a relationship.
For example, the relationship *works-for* could be ordered pairs of
*employee* entities.
The first employee takes the role of manager, and the second one will take
the role of worker.

A relationship may also have **descriptive** attributes.
For example, *date* (last date of account access) could be an attribute
of the *CustAcct* relationship set.

Page created and maintained by Osmar R. Zaï ane

Last Update: Sun Sep 10 17:02:35 PDT 1995