Search CTRL + K

Candidate Key

关系模型 数据库 中,当某个 超键 不包含无关列,也就是说“最小”了,就被成为 候选键

一个 中可能会有多个 候选键


Database System Concepts

We are often interested in superkeys for which no proper subset is a superkey. Such minimal superkeys are called candidate keys.[1]


  1. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, Seventh edition (New York, NY: McGraw-Hill, 2020). P44 ↩︎