Relationship Diagram

The schema of a relationship is defined by :

  • The name of the relationship

  • List of attributes

Note: R (A1, A2, ... , An).

Example

Student (last name, first name, birth)

Product (Reference, designation, color)

Let the relationship

CATALOG_PRIX (Product_Code , Description , Supplier , Price).

This relationship is defined by its attributes, which are : Product_Code , Description, Supplier and Price.

Its name is: CATALOG_PRIX.

A table representation of this relationship, where the columns correspond to the attributes and the rows to the tuples of the relationship, would be :