KwickClips Databases and SQL · 40 sec · free
What is an orphan record?
Short answer. A child row with no matching parent.
What does No action do on delete?
It blocks the delete.
Referential integrity
| Foreign key must exist |
| Unknown AdmNo is refused |
| No orphan records |
Remember
| Child needs a real parent |
| No action blocks deletes |
A receipt for a missing student? Not with referential integrity. Foreign keys must exist in the parent. Unknown numbers are refused. No orphans. Two points. A child needs a real parent. No action blocks deletes.
This clip is from the full lesson: Relationships Between Tables in Base — 7 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 10 Information Technology (402)
More KwickClips from this lesson
What is redundancy?41 sec
Which relationship is most common?41 sec
Where do you create a relationship?41 secVoice-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.