Databases — Data Integrity

Question 1

List

Types of database anomalies

Answer 1

• Update
• Insert
• Delete

Question 2

Define

Update anomaly

Answer 2

When data that’s stored in multiple locations isn’t updated in every location.

Question 3

Define

Insert anomaly

Answer 3

When data cannot be added since it’s incomplete.

(i.e., missing required columns)

Question 4

Define

Delete anomaly

Answer 4

Where deleting one piece of data also leads to the deletion of another piece of data.

(e.g., in a table of drivers and license plates, if a driver who owns a single license plate is deleted, the license plate data is deleted too.)