Advertisements
Advertisements
Questions
Give one difference between alternate key and candidate key.
Differentiate between candidate key and alternate key.
Distinguish Between
Advertisements
Solution
| Basis of Difference | Candidate Key | Alternate Key |
|---|---|---|
| Meaning | A unique key that is eligible to become the primary key. | A candidate key that is not selected as the primary key. |
| Selection | It may be selected as the primary key. | It has already not been selected as the primary key. |
| Number | A table may have several candidate keys. | There may be one or more alternate keys. |
| Example | AdNo and Name are candidate keys. |
If AdNo is primary, Name becomes the alternate key. |
shaalaa.com
Notes
Students should refer to the answer according to their question.
Keys in a Relational Database
Is there an error in this question or solution?
