4.3.2 Keys

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