Advertisements
Advertisements
प्रश्न
Give one difference between alternate key and candidate key.
Differentiate between candidate key and alternate key.
अंतर स्पष्ट करें
Advertisements
उत्तर
| 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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
