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

Data redundancy and why we normalise

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

Storing the same fact in more than one place wastes space and, worse, lets copies disagree. Normalisation is the process that removes this redundancy from relational databases (spec 12.2.1 and 12.2.2).

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

Practise this lesson

Data redundancy

Data redundancy means the same data item is stored more than once, usually in a single flat table or in several unlinked files.

Example: a flat ORDERS table stores the customer's name and address on every order line, so a customer with 30 order lines has their address stored 30 times.

Problems caused by redundancy (anomalies)

Normalisation and why it is needed

Normalisation is a formal method of organising data into a set of related tables (relations) so that each fact is stored once, in the table where it belongs, linked by primary and foreign keys.

Benefits: removes redundancy and the update, insertion and deletion anomalies; improves consistency and integrity; saves storage; makes the database easier to maintain and extend; supports referential integrity.

Drawbacks: more tables, so queries need joins, which can be slower and harder to write; very large reporting systems (such as data warehouses) sometimes deliberately keep some redundancy for speed.

Key terms

TermMeaning
Entity / relationA table about one thing, such as CUSTOMER
AttributeA field (column), such as Surname
TupleA record (row)
Primary key (PK)Attribute(s) that uniquely identify each record
Composite keyA primary key made of two or more attributes
Foreign key (FK)An attribute that is the primary key of another table, used to link them
Functional dependencyA determines B if each value of A gives exactly one value of B (CustomerID determines CustomerName)

Worked example

A flat table of 9 order lines contains one customer on 6 of the lines. The customer's address is 40 bytes. How much space is wasted storing the address redundantly, and what happens if the customer moves?

  1. The address is needed once but is stored 6 times
  2. Redundant copies = 6 - 1 = 5
  3. Wasted space = 5 x 40 = 200 bytes
  4. If the customer moves, all six copies must be updated; missing one causes an update anomaly and inconsistent data

Answer: 200 bytes wasted, plus a risk of inconsistent addresses

Key idea: Redundancy = the same data stored more than once. It wastes space and causes update, insertion and deletion anomalies. Normalisation stores each fact once in linked tables.

Check yourself

  1. What is data redundancy?
    • Data that is out of date
    • Unnecessary repetition of the same data item
    • Data that has been encrypted
    • Data that has been deleted
    Show answer

    Unnecessary repetition of the same data item. Redundant data is duplicated.

  2. A supplier's phone number is stored on 200 product rows. It is changed on 199 rows only. What is this called?
    • An insertion anomaly
    • A deletion anomaly
    • A transposition error
    • An update anomaly
    Show answer

    An update anomaly. Missing one copy when updating leaves inconsistent data.

  3. A new course cannot be recorded until a student enrols on it, because course details are stored only on enrolment rows. Which problem is this?
    • Update anomaly
    • Insertion anomaly
    • Deletion anomaly
    • Concurrency problem
    Show answer

    Insertion anomaly. You cannot insert one fact without another.

  4. Deleting the last booking for a hotel guest also removes the guest's contact details. Which anomaly is this?
    • Update anomaly
    • Insertion anomaly
    • Deletion anomaly
    • Validation error
    Show answer

    Deletion anomaly. Deleting one fact removes another.

  5. A customer's 25-character name is stored on 12 order rows in a flat table. How many characters are redundant?
    Show answer

    275 characters. It is needed once; the other 11 copies of 25 characters are redundant: 275.

  6. Which is a drawback of a fully normalised database?
    • It stores more duplicate data
    • It causes more update anomalies
    • Queries often need joins across several tables, which can be slower
    • It cannot use primary keys
    Show answer

    Queries often need joins across several tables, which can be slower. More tables means more joins.

  7. Explain why normalisation improves data integrity.
    Show answer

    Each fact is stored only once, so when it changes it is updated in one place and copies cannot become inconsistent.. Stored once, so one update, so no inconsistent copies.

Practise with instant feedback

Sources

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