Data Anomalies
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What are Data Anomalies?
2. Which of the following is NOT one of the four types of Data Anomalies listed?
3. What is a Redundancy anomaly?
4. Which two practices play a vital role in making sure data anomalies do not occur?
5. In the de-normalised employee table example, a rule says department name cannot be NULL. What anomaly arises when a new employee has not yet been assigned a department?
6. In the de-normalised employee table example, what happens when the only employee in the HR department is deleted?
7. In the employee table example, Adam has two departments, IT and Procurement. What update anomaly can occur when renaming IT to Tech Org?
8. Besides eliminating duplication of records, what other benefit is gained by normalising the employee table into separate department and salary tables?
9. Which statement about data quality is made in the discussion of Data Anomalies?
10. How is an Update anomaly defined?