what is the candidate key , alternate key and composite key and why do we use all of these
Candidate Key :
A column or set of columns that can uniquely identify a row in a table.
Alternative key :
Any candidate key that has not been selected as the primary key.
Compound Key :
A key consisting of several columns.