candidate key


Also found in: Wikipedia.

candidate key

(database)
One of several possible attributes or combinations of attributes which can be used to uniquely identify a body of information (a "record"). The chosen candidate key is called the primary key.

candidate key

One or more columns (fields) in a relational database that can uniquely identify a row in the table. If there are two or more candidate keys, only one is selected as the "primary." See primary key.
References in periodicals archive ?
1 Step 1: Discriminate non-shot transition frames as candidate key frames
2 Step 2: Discriminate non-informative candidate key frames
Candidate key frames from Step 1 are further classified into informative and non-informative frames.
83) Source of Normal Forms Design Principles Anomaly Functional 1NF, 2NF, BCNF: Design tables so that every Dependencies 3NF, BCNF determinant is a candidate key Multivalued 4NF 4NF: Move each multivalued Dependencies dependency to a table of its own Data constraints 5NF, DK/NF DK/NF: Make every constraint a and oddities logical consequence candidate keys and domains.
Key phrase extraction from a body of text relies on an evaluation of the importance of each candidate key phrase [4].
These methods generate single keywords or multiword keyterms or a mixture of the above two by a critical evaluation of the significance of each candidate key phrase in the source documents.
More explicitly, KEA chooses a set of candidate key phrases from input documents.
Such an attribute, or combination of attributes, is called a candidate key.
The following example of an answer to Q1 (foreign key), given by a UNInoexp-student, was awarded two points, despite the slightly misguided claim that candidate key is a synonym for primary key.
The primary key was the concept about which the students had the best knowledge, followed by the foreign key, and finally the candidate key.
ISAKMP is the leading candidate key management standard in the Internet Engineering Task Force (IETF).
High amongst the candidate keys for re-labelling is the 'help' button.

Full browser ?