What is 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.
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.
--------------------------------------------------------------------------------------------------------