When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____.
A) cannot occur
B) causes a loss of data that may not be stored anywhere else
C) is helpful in reducing the amount of redundant data present
D) causes additional redundant data to appear
E) occurs as the result of an insertion anomaly

Question

Quizplus · Accepted Answer

Merging different kinds of data in one file can lead to a deletion anomaly. A deletion anomaly occurs when deleting a piece of data results in the loss of other related data that may not be stored anywhere else. This is because the data is not properly separated into different tables that are logically connected through relationships. This type of anomaly can cause significant data integrity issues in a database.

When Different Kinds of Data (Data About Different Entities) Are