Records to store data

The use of records to store data

2.2.3 Additional Programming Techniques

Additional Programming Techniques — Note 4 of 12

Use of 2D arrays to emulate database tables of a collection of fields, and records

What you need to know

A record is a data structure used to group related data of different types under one structure, similar to a row in a database table. Each piece of data in a record is called a field, and fields can have different data types (e.g. string, integer, Boolean). In Python, records can be represented using dictionaries or classes.

What to know

Each item in a record is called a field and can be a different data type.
Records are similar to a single row in a database table.
Example: a student record might have fields for name (string), age (integer), and enrolled (Boolean).
In Python, dictionaries or classes can be used to represent records.
2D arrays can also emulate a collection of records (a table of fields and records).

Key terms

Data Structure: A method of organising and storing data so that it can be accessed and used efficiently. Examples include arrays, records, and 2D arrays.
Record: A data structure that can hold multiple pieces of data of varying data types, grouped together as a single entity.

Code examples

Record using a dictionary

python

# A record as a dictionary
student = {
    "name": "Alice",
    "age": 16,
    "enrolled": True
}

print(student["name"])   # Output: Alice
print(student["age"])    # Output: 16

Ready to test yourself?

Practise 2.2.3 questions

← Previous noteOpen, Read, Write, Close2.2.3 Additional Programming Techniques Next note →SQL to search for data2.2.3 Additional Programming Techniques

Back to Additional Programming Techniques

Revise another OCR GCSE topic: Programming Fundamentals