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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

The Exhibit Shows a Table Called Activity Relation That Relates