4.3.2 Keys

Cards (3)

  • Names, dates of birth or addresses in Student_Table cannot be used as unique keys
  • Real-world example of a key
    • Open University personal identifier (e.g. A123456)
  • The new Student entity table is shown below, with names and addresses ordered by ascending student number. The key field itself – Student_Number − is shown in bold.