KwickClips Databases and SQL · 41 sec · free
What is a foreign key?
Short answer. A column that refers to another table's primary key.
Must its value exist in the other table?
Yes.
Remember
| Foreign key points to a primary key |
| Its values can repeat |
The fee table has no names. So how does it know who paid? Read receipt five zero two. Its admission number is one zero zero three. Find it in Student. It is Riya Shah. A foreign key points to another table's primary key. It can repeat.
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.