All subjects · Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development

Data integrity, data governance and data dictionaries

Edexcel IAL Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development

Organisations make decisions from their data, so the data must be accurate, complete and consistent. This lesson covers why data integrity matters, how data governance protects it, and how a data dictionary documents every field (spec 12.1.1 to 12.1.3).

Practise this in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise this lesson

What data integrity means

Data integrity is the accuracy, completeness, consistency and reliability of data across its whole life: when it is entered, stored, processed, transmitted and archived.

Why it matters:

Integrity can be lost through human input errors, transmission errors, software bugs, hardware failure, duplicated (redundant) data that gets out of step, and deliberate tampering.

Data governance

Data governance is the set of policies, roles and processes an organisation uses to manage its data so that it stays accurate, secure and usable. It typically covers:

Maintaining integrity in practice: validation rules, verification (double entry, proofreading), referential integrity in relational databases, normalisation to remove redundancy, backups, access control and audit logs.

The data dictionary

A data dictionary is a central store of metadata (data about the data) describing every data item in a system. For each field it typically records:

Functions: it gives developers and users one agreed definition of each item; it supports consistency across tables and systems; it helps design validation; it makes maintenance and training easier; a DBMS can use it to enforce rules.

Reading and building a data dictionary

Field nameData typeSize (bytes)ValidationKey
StudentIDText6Format: 2 letters + 4 digitsPK
SurnameText30Presence check
DateOfBirthDate8Range: age 16 to 25 on 1 September
TutorText4Lookup in TUTOR tableFK
FeesPaidBoolean1Y or N only

Example: a STUDENT table. Estimated record size = 49 bytes.

Worked example

Use the data dictionary above to estimate the storage needed for 1200 student records, adding 10% for overheads. Give your answer in kilobytes (1 kB = 1000 bytes).

  1. Record size = 6 + 30 + 8 + 4 + 1 = 49 bytes
  2. 1200 records x 49 = 58800 bytes
  3. Add 10%: 58800 x 1.1 = 64680 bytes
  4. = 64.7 kB

Answer: About 64.7 kB

Key idea: Integrity = accurate, complete, consistent, reliable data. Governance = the policies, roles and controls that keep it so. A data dictionary holds metadata for every field: name, type, size, format, validation, keys, description.

Check yourself

  1. Which statement best defines data integrity?
    • Data is encrypted when it is stored
    • Data can be accessed from anywhere
    • Data is accurate, complete and consistent throughout its life
    • Data is stored in a cloud data centre
    Show answer

    Data is accurate, complete and consistent throughout its life. Integrity is about correctness and consistency, not location or secrecy.

  2. Which is part of data governance?
    • Assigning a named owner who is responsible for the accuracy of each data set
    • Buying faster hard drives
    • Choosing a colour scheme for forms
    • Increasing network bandwidth
    Show answer

    Assigning a named owner who is responsible for the accuracy of each data set. Governance sets ownership, standards, quality controls and access rules.

  3. What does a data dictionary store?
    • The actual customer records
    • A backup copy of the database
    • Metadata such as each field's name, data type, size and validation rule
    • The program code of the DBMS
    Show answer

    Metadata such as each field's name, data type, size and validation rule. It describes the data; it does not hold the data values.

  4. A record has fields of 6, 30, 8, 4, 1 bytes. What is the record size in bytes?
    Show answer

    49 bytes. Add the field sizes: 49 bytes.

  5. A table holds 5000 records of 49 bytes. What is the total size in kilobytes (1 kB = 1000 bytes)?
    Show answer

    245 kB. 5000 x 49 = 245000 bytes = 245 kB.

  6. Explain why a data dictionary helps maintain data integrity when several developers work on one system.
    Show answer

    Everyone uses the same agreed definitions, data types and validation rules for each field, so data is stored consistently across tables and systems.. Link: shared definitions, so consistent data, so fewer errors.

  7. Which is most likely to cause a loss of data integrity?
    • Using a primary key in each table
    • Running regular backups
    • Adding validation rules
    • The same customer address stored in three tables and updated in only one
    Show answer

    The same customer address stored in three tables and updated in only one. Redundant copies drift out of step, making data inconsistent.

Practise with instant feedback

Sources

Last updated 8 November 2026. Spotted a mistake? Tell us.