$\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 |
Grade
Cardinality
Supervisor - Student
is a relation of Grade 2Example 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 |