Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Which term describes the rejoining of relations that have been decomposed?

1. A. Normalization
2. B. Denormalization
3. C. Referential integrity
4. D. Domain constraints

Correct Answer: B