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.