Keys

Tips:

  • joining is easiest if primary and foreign key have the same name
  • check the primary keys!
    • each value must occur only once
    • there must be no missing values