Which of the following occurs in a relation when records are added or removed?
Which concurrency control method should be used only when conflicts between transactions
rarely occur?
Consider the relation shown in the exhibit. Which of the following SQL statements would
properly add information for a new employee?
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?
What is the highest normal form of the relation(s) shown in the exhibit?
