Using the Transcript table, write an SQL statement that
a. Deregisters the student with Id = 123456789 from the course CS305 for the fall of 2001
b. Changes to an A the grade assigned to the student with Id = 123456789 for the course CS305 taken in the fall of 2000
c. Returns the Id of all students who took CS305 in the fall of 2000
a. ```
DELETE
FROM Transcript
WHERE StudId = ’123456789’
AND CrsCode = ’CS305’ AND Semester = ’F2001’
```
b. ```
UPDATE Transcript
SET Grade = ’A’
WHERE StudId = ’123456789’
AND CrsCode = ’CS305’ AND Semester =’F2000’
```
c. ```
SELECT StudId
FROM Transcript
WHERE CrsCode = ’CS305’ AND Semester = ’F2000’
```
You might also like to view...
Which of the following statements about creating arrays and initializing their elements is false?
a. The new keyword should be used to create an array. b. When an array is created with operator new, the number of elements must be placed in square brackets following the type of element being stored. c. The elements of an array of integers have a value of null before they are initialized. d. A for loop is commonly used to set the values of the elements of an array.
A page element is ____.
A. an object B. text C. a pixel D. either A or B
Indices like the one in the accompanying figure are tiny charts that fit inside one cell.
Answer the following statement true (T) or false (F)
The ________ directs Excel to trust files in particular folders or created by certain users.
Fill in the blank(s) with the appropriate word(s).