- 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
| Term | Meaning |
|---|---|
| Redundancy | Unnecessary repetition of the same data |
| Data integrity | Data is accurate, consistent and follows rules |
| Normalisation | Organising tables to reduce redundancy and avoid anomalies |
| Anomaly | A problem that arises from poor design when inserting, updating or deleting |
| Data dictionary | A description of the database's tables, fields and types |
| Backup | A 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.
Key takeaways: avoid repeating data, link tables with keys and enforce rules to keep data correct.
Check your understanding
-
1. Unnecessary repetition of the same data is called
- Integrity
- Normalisation
- A data dictionary
- Redundancy
Show answer
Answer: D. Redundancy is repeated data; normalisation is the process that reduces it.
-
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
- 500
- 250
- 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. A rule says marks must be between 0 and 100. Which idea does this enforce?
- Redundancy
- Data integrity
- Data dictionary
- Backup
Show answer
Answer: B. Rules that keep data accurate and valid enforce data integrity.
-
4. A description of a database's tables, fields and their types is a
- Backup
- Anomaly
- Data dictionary
- Query
Show answer
Answer: C. The data dictionary describes the structure of the database.
-
5. A problem caused by poor design when inserting, updating or deleting data is called
- A backup
- A primary key
- A data dictionary
- 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.