CBSE · 083Class XII · 2022Section A2 marks
Question 07
7 June 2022 · Computer Science (083)
Differentiate between Candidate Key and Primary Key in the context of Relational Database Model.
Answer
Candidate Key: A table may have more than one or a combination of attribute(s) that identifies a tuple uniquely. All such attribute(s) are known as Candidate Keys. Primary Key: Out of all the Candidate keys, the most appropriate one, which is used for unique identification of the Tuples, is called the Primary Key.
Explanation
Candidate Keys are all possible unique identifiers; the Primary Key is the specific one chosen to identify rows.