Câu 10: 1D0-541: CIW v5 Database Design Specialist

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?

1. A. An update anomaly would occur.
2. B. An insertion anomaly would occur.
3. C. A deletion anomaly would occur. — đáp án hiện tại
4. D. Both an insertion anomaly and a deletion anomaly would occur.