Thursday, 26 December 2013

What is the Difference between Candidate Key, Alternate Key, and Composite Key

Explain Candidate Key, Alternate Key, and Composite Key

Candidate Key :
A Candidate Key is one that can uniquely identify each row of a table.Generally a candidate key becomes the Primary Key of the table. 

Alternate Key:
If the table has more than one Candidate Key, one of them will become the Primary Key, and the rest are called Alternate Keys.

Composite Key : 
A key formed by combining at least two or more columns is called Composite Key.

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts