KwickClips Databases and SQL · 40 sec · free
What is a record?
Short answer. One row: all the data about one item.
Why can a title not be the primary key?
Two books can share a title.
Parts of a table
| Word | Means |
|---|---|
| Field | a column |
| Record | a row |
| Primary key | unique field |
Remember
| Field is a column |
| Record is a row |
Exams mix these up. Do you know which is which? Learn three words. A field is one column. A record is one row. A primary key is a field unique for every record. Quick check. Field is a column. Record is a row.
This clip is from the full lesson: SQL for Cambridge IGCSE: Single-table Databases and Queries — 8 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 10 Computer Science (0478)
More KwickClips from this lesson
Which keyword sorts largest first?45 sec
Why do marks get lost?42 sec
What is the difference between validation and verification?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.