The Exhibit Shows a Table Called Activity Relation That Relates

Multiple Choice

The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

A) An update anomaly would occur.
B) An insertion anomaly would occur.
C) A deletion anomaly would occur.
D) Both an insertion anomaly and a deletion anomaly would occur.