Choose Index below for a list of all words and phrases defined in this glossary.


Candidate key

index | Index

Candidate Key - definitions

Candidate key : A key that can serve to uniquely identify occurrences of an entity type. A candidate key must have two properties : (1) Each occurrence or record must have a different value of the key, so that a key value identifies only one occurrence; and (2) No attribute in the key can be eliminated without nullifying the first property. 

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml External, 14-Jan-2009 14:20


These advertisers support this free service


Candidate key - 1) One or more fields that will uniquely identify one record in a table.

2) A potential primary key.

Source: Northwest Database Services, 10 November 2009 08:06:56, http://www.nwdatabase.com/database-glossary-k.htm External


candidate key - [computing] In a relational database, any key that can be used as the primary key in a table.

[Category=Geospatial ]

Source: esri, 09 February 2012 09:13:13, http://support.esri.com/en/knowledgebase/GISDictionary/term/abbreviation External


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl