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 deletion anomaly would occur because removing the tuple for Student_ID 1001 would result in the loss of information about which activity the student was enrolled in and its associated fee. Deletion anomalies result in unintended loss of data when a record is deleted, which is precisely what happens in this case.
Correct Answer: C. A deletion anomaly would occur.