Candidate Key -C A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key. Primary Key -C A Primary Key is a column or a combination of columns that uniquely identify a record.read more >>