What does the Data organisation and databases content in WJEC GCSE Computer Science cover?

It covers the common data types (integer, real, Boolean, character and string), data structures such as arrays and records, the difference between validation and verification, what a database is, the terms table, record, field and primary key, the difference between flat-file and relational databases, distributed systems, and data security and integrity including backups, archiving and processes that keep data accurate. It is part of Unit 1.

What is the difference between an array and a record?

An array stores many values of the same data type under one name, with each value accessed by its index or position, for example the marks of a whole class. A record stores several related values that may be of different data types together as one item, like a row in a database, for example a pupil's name as a string, age as an integer and whether they have paid as a Boolean. Arrays group same-type items; records group mixed-type fields describing one thing.

What is the difference between a flat-file and a relational database?

A flat-file database stores all its data in a single table, which often repeats the same data in many records. A relational database stores data in two or more linked tables related using key fields, so shared data is stored once and linked to. The relational design reduces data duplication, saves space, makes updates easier and keeps data more consistent, which is why most real databases are relational.

What is the difference between validation and verification?

Validation checks that entered data is sensible and follows set rules, using checks such as a range check, presence check or format check, so obviously wrong data is rejected at input. Verification checks that data has been entered or copied correctly, using methods such as double entry or a visual check against the original. Validation checks data is reasonable; verification checks it was entered without mistakes. Neither guarantees the original data was correct.

What is the difference between a backup and an archive?

A backup is a copy of current, in-use data kept so it can be restored if the original is lost, damaged or corrupted, while the original stays in use. An archive is the long-term storage of data that is no longer in regular use but must be kept, which is moved out of the main system to free space and retrieved only occasionally. A backup is for recovery of current data; an archive is for long-term storage of old data.

WalesComputer Science

WJEC GCSE Computer Science Data organisation and databases: a complete overview of data types, structures, databases and data integrity

A deep-dive WJEC GCSE Computer Science guide to the Data organisation and databases content in Unit 1. Covers the common data types, data structures such as arrays and records, validation and verification, databases and their key terms, flat-file versus relational databases, distributed systems, and data security and integrity, with the exam patterns WJEC repeats.

Generated by Claude Opus 4.812 min read3500 Unit 1 Organisation and structure of dataUpdated 2026-06-15

Reviewed by: AI editorial process; not yet individually human-reviewed

Jump to a section

What the Data organisation and databases content demands
Data types and structures
Databases
Data security and integrity
Check your knowledge

What the Data organisation and databases content demands

This area is where WJEC checks that you understand how data is described, structured, stored in databases, and kept accurate and safe. The data-type, database-term and validation-versus-verification questions appear regularly, and the flat-file-versus-relational and backup-versus-archive distinctions are reliable marks. The content links to programming (data types and structures are used in code) and to cyber security (security and integrity protect data from loss and tampering).

This guide walks through the Data organisation and databases content and ties together the matching dot-point pages, each of which has its own worked examples and practice questions.

Data types and structures

The common data types are integer (whole numbers), real/float (decimals), Boolean (true/false), character (one symbol) and string (text); choosing the right type matters, as a price needs a real type to keep the pence. A data structure organises related data: an array stores many values of the same type accessed by index, while a record stores related values of different types together, like a database row. Validation checks data is sensible and follows rules; verification checks it was entered correctly.

Databases

A database is an organised store of data that can be searched, sorted and updated. The key terms are table (rows and columns), record (one row, all the data about one item), field (one column, one kind of data) and primary key (a field with a unique value identifying each record). A flat-file database uses one table and often repeats data; a relational database uses two or more linked tables, reducing duplication and keeping data consistent. A distributed system spreads data or processing across several connected computers.

Data security and integrity

Data security keeps data safe from loss, theft and unauthorised access; data integrity keeps it accurate, complete and consistent. A backup is a copy of current data for recovery, ideally regular and kept separately, and may be full or incremental. An archive moves old data no longer in regular use into long-term storage to free space. Integrity is maintained by validation, verification, access control and audit logs.

Check your knowledge

A mix of data-type, structure, database and integrity questions covering the Data organisation and databases content. Attempt them under timed conditions, then check against the solutions.

State a suitable data type for a price in pounds and pence. (1 mark)
State the difference between an array and a record. (2 marks)
Name one validation check and describe it. (2 marks)
State the difference between validation and verification. (2 marks)
Explain the terms record and field in a database. (2 marks)
State one advantage of a relational database over a flat-file database. (1 mark)
State the difference between a backup and an archive. (2 marks)
State what data integrity means. (1 mark)

Solutions

Q1: Real (also called float), so the pence are not lost.
Q2: An array stores many values of the same type accessed by index; a record stores related values of different types together (like a database row).
Q3: A range check ensures a value lies between set limits (for example a month between 1 and 12).
Q4: Validation checks data is sensible and follows rules; verification checks data was entered or copied correctly.
Q5: A record is a single row holding all the data about one item; a field is a single column holding one kind of data for every record.
Q6: It reduces data duplication (so updates are easier and data is more consistent).
Q7: A backup is a copy of current data for recovery; an archive is old data moved to long-term storage to free space.
Q8: That data is accurate, complete and consistent, and has not been corrupted or changed in error.

Sources & how we know this

WJEC GCSE Computer Science specification (3500) from 2017 — WJEC (2017)