Topic 2: Fields and Records
In a database, a field represents a single piece of data (like a name), while a record is a complete set of related fields (like one student
Core concept
A field is a single category of data, like 'Name', 'Age', or 'Class', representing one specific type of information.
How it works
A record combines multiple fields to represent one complete entry, like a student's Name, Age, and Class together.
Why it matters
A table in a database organises many records, with fields as columns and each record as a row.
Key detail
Understanding fields and records helps us design and navigate databases effectively for storing organised information.
Exam highlight
Key diagram

- A picture showing a table with columns labelled as fields and one row highlighted as a record.
Keywords worth remembering
Trending
Most searched
Study resources
Notes & downloads
Quick notes
• A field is a single category of data.
• Examples: Name, Age, Class.
• A record combines multiple fields for one entry.
• Example: one student's Name, Age, Class together.
• A table organises many records.
• Fields are columns; records are rows.
• This structure organises database information.
• Understanding this helps design databases.