What is Relation?

$\Delta_1, \Delta_2, ... \Delta_m$ $\Delta_1 \times \Delta_2 \times ... \Delta_m$ is the set of tuples

$\pi \in \Delta_1 \times \Delta_2 \times ... \Delta_m$ → Relation is the subset of Cartesian Product

<aside> 💡 A relation in the relation model is a relation where each domain has a unique name

</aside>

Example 1.

Name Relation: Supervisor - Student

ATTRIBUTES
SUPERVISOR STUDENTS
E A ← INSTANCE = TUPLES
N C
P E

Example 2.

STUDENT ID (string) NAME (string) SURNAME (string) EMAIL (string) ADDRESS (string)
VR001 LUCA ROSSI [email protected] XXX
VR002 LUCA ROSSI [email protected] XXX
VR003 ANNA BIANCHI [email protected] XXX