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).
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:
- Decisions: managers act on reports; wrong data gives wrong decisions (ordering too much stock, sending invoices to the wrong address).
- Money and reputation: errors cost money to fix and damage customer trust.
- Legal duties: many countries' data protection laws require personal data to be accurate and kept up to date.
- Linked systems: an error in one table spreads to every report and system that uses it.
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:
- Ownership and roles: who is responsible for each data set (data owners, data stewards) and who may change it.
- Standards: agreed names, formats and definitions (often recorded in a data dictionary) so every department means the same thing by 'customer' or 'order date'.
- Quality controls: validation and verification at input, regular audits and data cleansing.
- Security and access: access rights, encryption, audit trails showing who changed what and when.
- Life cycle: how long data is kept, when it is archived and how it is deleted.
- Compliance: meeting legal and regulatory requirements.
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:
- field name and description
- data type (text, integer, real, date, Boolean) and field size or length
- format or input mask (for example DD/MM/YYYY)
- validation rule and error message
- whether it is a primary key or foreign key, and which table it links to
- whether it is required, a default value, and an example
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 name | Data type | Size (bytes) | Validation | Key |
|---|---|---|---|---|
| StudentID | Text | 6 | Format: 2 letters + 4 digits | PK |
| Surname | Text | 30 | Presence check | |
| DateOfBirth | Date | 8 | Range: age 16 to 25 on 1 September | |
| Tutor | Text | 4 | Lookup in TUTOR table | FK |
| FeesPaid | Boolean | 1 | Y 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).
- Record size = 6 + 30 + 8 + 4 + 1 = 49 bytes
- 1200 records x 49 = 58800 bytes
- Add 10%: 58800 x 1.1 = 64680 bytes
- = 64.7 kB
Answer: About 64.7 kB
Check yourself
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (first teaching 2018), Issue 2, February 2021
- Pearson Edexcel IAL Information Technology: scheme of work for Unit 3
Last updated 8 November 2026. Spotted a mistake? Tell us.