Question: Please compelet answer do not hand writing Q3-Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer
Please compelet answer do not hand writing
Q3-Answer the following questions by referring to the tables below.
COURSE
| Course_name | Course_number | Credit_hours | Department |
| Intro to Computer Science | CS1310 | 4 | CS |
| Data Structures | CS3320 | 4 | CS |
| Discrete Mathematics | MATH2410 | 3 | MATH |
| Database | CS3380 | 3 | CS |
SECTION
| Section_ID | Course_number | Semester | Year | Instructor |
| 85 | MATH2410 | Fall | 07 | King |
| 92 | CS1310 | Fall | 07 | Anderson |
| 102 | CS3320 | Spring | 08 | Knuth |
| 112 | MATH2410 | Fall | 08 | Chang |
| 119 | CS1310 | Fall | 08 | Anderson |
| 135 | CS3380 | Fall | 08 | Stone |
A- Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name.
B- Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson".
C- Insert a tuple for a new COURSE with the following information: The course name is Computer networks, and the course number is CS3480. It belongs to the CS department and has a 4-hours credit.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
