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?
A.
UPDATE Recreation SET Activity,
Activity_Fee (‘Tennis’,100) WHERE
Student_ID = 1003;
B.
UPDATE TABLE Recreation ALTER COLUMN ACTIVITY
SET ACTIVITY = ‘Tennis’, Activity_Fee = 100 WHERE
Student__ID = 1003 AND Activity = wimming?AND Activity =
?wimming?
C.
UPDATE Recreation SET Activity =
‘Tennis’, Activity_Fee = 100 WHERE
Student_ID = 1003 AND Activity =
‘Swimming’;
D.
DELETE Activity FROM
Recreation WHERE
Student_ID = 1003; INSERT
INTO Recreation VALUES (1003, ‘Tennis’, 100);