1.3.04. Pointing mechanism | Lightenna

1.3.04. Pointing mechanism

Relation has a Primary key
Tuple contains Primary key value
Foreign keys

Tuples can contain a reference to another relation's Primary key

Just numbers

Relational model foreign key example

One number identifies a single tuple in one relation (local), one number identifies a single tuple in another relation (foreign).

s5 slideshow