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).