KwickClips Databases and SQL · 41 sec · free
What is redundancy?
Short answer. The same data stored many times.
How are split tables joined?
By a common field, like AdmNo.
Split and link
| Redundancy wastes space |
| Repeats invite mistakes |
| Link tables by AdmNo |
Remember
| Store each fact once |
| Link with a common field |
Why retype a name for every receipt? Repeated data is redundancy. It wastes space. It invites typing mistakes. So split tables, linked by admission number. Two rules. Store each fact once. Link with a common field.
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
Which relationship is most common?41 sec
Where do you create a relationship?41 sec
What is an orphan record?40 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.