KwickClips Databases and SQL · 37 sec · free
What is an alternate key?
Short answer. A candidate key not chosen as primary.
If AdmNo is primary, what is Email?
An alternate key.
Alternate key
| Column | Key type |
|---|---|
| AdmNo | Primary |
| Alternate |
Remember
| Alternate: candidate not chosen |
| Candidate = primary + alternate |
What do we call a candidate key that was not chosen? Both were candidates. Admission number is the primary key. So email is the alternate key. An alternate key is a candidate key not chosen. Candidate keys equal primary plus alternate.
This clip is from the full lesson: Keys in a Database: Primary, Candidate, Alternate and Foreign Key — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 9 Information Technology (402), CBSE Class 10 Information Technology (402), CBSE Class 10 Information Technology (402), CBSE Class 12 Computer Science (083)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.