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?
The Exhibit Sho 1 (51.89 KiB) Viewed 66 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!