The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports act
Posted: Sat Jul 23, 2022 7:29 pm
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.
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 68 times
B. An insertion anomaly would occur.
C. A deletion anomaly would occur.
D. Both an insertion anomaly and a deletion anomaly would occur.