• Practice
  • About 12 min
  • 5 practice questions

Data integrity, redundancy and normalisation

Explain redundancy, anomalies and the purpose of normalisation in plain language.

If something looks wrong, please tell us.

Good databases avoid repeating data and keep it correct. These ideas are tested as definitions, so learn each in one line.

Key terms

Terms
TermMeaning
RedundancyUnnecessary repetition of the same data
Data integrityData is accurate, consistent and follows rules
NormalisationOrganising tables to reduce redundancy and avoid anomalies
AnomalyA problem that arises from poor design when inserting, updating or deleting
Data dictionaryA description of the database's tables, fields and types
BackupA copy of the data to restore after loss

Why repeated data is a problem

Suppose a student's address is stored in ten rows. If it changes, you must update all ten. Missing one makes the data inconsistent. Storing the address once in a separate table and linking it with a key avoids this.

Worked examples

Example 1. A course name is typed in 500 records. Later it is renamed. How many updates are needed in the poor design versus a normalised one? In the poor design, 500 records. In a normalised design, one record in the Course table.

Example 2. A rule says marks must be between 0 and 100. Which idea does this enforce? Data integrity.

Normalisation reduces redundancy. Integrity keeps data correct and consistent.

— Remember this

Key takeaways: avoid repeating data, link tables with keys and enforce rules to keep data correct.

Check your understanding

  1. 1. Unnecessary repetition of the same data is called

    1. Integrity
    2. Normalisation
    3. A data dictionary
    4. Redundancy
    Show answer

    Answer: D. Redundancy is repeated data; normalisation is the process that reduces it.

  2. 2. A course name is typed in 500 records and is later renamed. In a normalised design with a separate Course table, how many records must be updated?

    1. 1
    2. 500
    3. 250
    4. 0
    Show answer

    Answer: A. The name is stored once in the Course table and linked by a key, so one update is enough.

  3. 3. A rule says marks must be between 0 and 100. Which idea does this enforce?

    1. Redundancy
    2. Data integrity
    3. Data dictionary
    4. Backup
    Show answer

    Answer: B. Rules that keep data accurate and valid enforce data integrity.

  4. 4. A description of a database's tables, fields and their types is a

    1. Backup
    2. Anomaly
    3. Data dictionary
    4. Query
    Show answer

    Answer: C. The data dictionary describes the structure of the database.

  5. 5. A problem caused by poor design when inserting, updating or deleting data is called

    1. A backup
    2. A primary key
    3. A data dictionary
    4. An anomaly
    Show answer

    Answer: D. Insert, update and delete anomalies come from poor design; normalisation avoids them.

Sign in to keep track of the lessons you finish.

Next lesson → Database mixed practice

Privacy · Terms · Refunds · Delivery