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 ?
On the other hand, if no candidate key arises, then one needs to dig deeper for a better understanding of what is happening.
But if all candidate keys are taken into account (that is considered here), although there are no partial dependencies on A, we have a partial dependency B [right arrow] D on candidate key BC, implying that the relation is not in 2NF.
1 Step 1: Discriminate non-shot transition frames as candidate key 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].
Such an attribute, or combination of attributes, is called a candidate key.
The two foreign keys combine to form a candidate key.
ISAKMP is the leading candidate key management standard in the Internet Engineering Task Force (IETF).
Each candidate key consists of the attribute or attributes used to label a distinct row in a table.
Any form field matching a common candidate key suffix such as NAME, NO, NUMBER, or # may represent an entity (e.
A candidate key is a set of attributes that uniquely identify each row.
High amongst the candidate keys for re-labelling is the 'help' button.

Full browser ?