In the table STUDENTB,when Green replaces her MATH major by a PHYSICS major,the following anomaly is evidenced:
A) update anomaly
B) insertion anomaly
C) deletion anomaly
D) none of the above

Question

Quizplus · Accepted Answer

An update anomaly occurs when updating data in a database results in inconsistencies or errors due to the data being stored in multiple tables. In this scenario, if Green updates her major from MATH to PHYSICS in the STUDENTB table, records in other tables that are related to her student ID may still have her listed as a MATH major, creating an inconsistency in the data. This is an example of an update anomaly.

In the Table STUDENTB,when Green Replaces Her MATH Major by a PHYSICS