Question Constellation Sign up for free

AQA · GCSE · Computer Science · Higher

Data inconsistency definition

Q18.2 2 marks

Explain what is meant by data inconsistency within a database.

Write your answer first. You can study the marking guidance whenever you need it.

Study the marking See what earns credit and compare it with a full-mark answer.

Marking points

  1. 1 States that the same data is stored in multiple places.
  2. 2 States that the stored copies are not identical.

Full-mark answer

Data inconsistency occurs when the same item of data is stored in more than one place but the copies do not have identical values, for example when one copy is updated and another is not.

Why this answer loses marks

The same data is stored more than once.

That describes redundancy only; inconsistency also requires the stored copies to have different values.