Use of Records to Store Data (AQA GCSE Computer Science): Revision Notes

Use of records to store data

What are records?

A record is a special type of data structure that lets you store multiple pieces of related information together in one place. Think of it like a digital filing system where each record is like a folder that contains several labelled compartments for different types of information.

Records are incredibly useful because they allow you to group related data items and give each piece of information a meaningful name, called a field name. This makes your data much more organised and easier to work with than storing individual pieces of information separately.

Understanding field names

Field names are like labels that identify each piece of information stored within a record. When you create a record, you first need to decide what field names you want to use. These field names should be descriptive and make it clear what type of information they will contain.

For example, if you were creating a record to store information about a student, you might choose field names such as:

• FirstName
• Surname
• YearGroup
• Email

Each field name acts as a unique identifier, making it easy to find and access specific pieces of information later.

Using records in database systems

Records are commonly used in database management systems to organise information efficiently. When you store records in a database, they are typically displayed in a table format, where each row represents one complete record and each column represents a different field.

This table shows how student records might be stored in a database. Each row contains all the information for one student, organised under the appropriate field names. This structure makes it easy to search for specific students or update their information.

Creating record structures

Before you can use records in a programme, you need to define their structure. This involves specifying what field names the record will have and what type of data each field will store.

Here's how you would define a record structure for storing student information:

RECORD Student
    FirstName: String
    Surname: String
    YearGroup: Integer
    Email: String
ENDRECORD

Let's break down this structure:

• RECORD Student - This starts the definition and gives the record a name
• Each line inside defines a field name and its data type
• String is used for text information like names and email addresses
• Integer is used for whole numbers like year groups
• ENDRECORD - This marks the end of the record definition

Data types in records

When defining records, you need to specify the data type for each field. This tells the computer what kind of information to expect:

• String - For text information (names, addresses, emails)
• Integer - For whole numbers (ages, year groups, quantities)
• Boolean - For true/false values
• Real/Float - For decimal numbers (prices, measurements)

Benefits of using records

Records offer several advantages when organising data:

• Organization - Related information is kept together in one structure
• Clarity - Field names make it obvious what each piece of data represents
• Efficiency - Easy to access specific information using field names
• Consistency - All records of the same type have the same structure
• Scalability - Easy to add new records or modify the structure when needed

These benefits make records an essential tool for managing data in both simple programmes and complex database systems.