Key

noun

say it: “KEE” /kiː/

In a table of data, a column (or a few columns together) whose value picks out exactly one row, or links a row to a row in another table, such as a student ID.

What is Key in a relational database?

Key — One or more attributes used to identify rows or connect related relations.

In a sentence

  • “The student ID is the key that links each score to the student's name.”
  • “A first name is a poor key, because ten students share it.”

Level: Novice · More Database terms at this level

Updated