What you'll learn
How data is organised in a database.
Key ideas
- A database holds organised data in tables.
- A record is a row; a field is one item; the primary key uniquely identifies a record.
- Queries retrieve data; validation checks it is sensible on entry.
Exam tips
- Choose a suitable primary key.
- Match data types to fields.
Common mistakes
- Confusing records and fields.
- Forgetting the role of the primary key.