** PLEASE NO HANDWRITING**

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

Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name.

Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson".

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.

\begin{tabular}{ll|l} Learning & Question TWO & 3 Marks \\ \cline { 2 - 3 } Outcome(s): & Answer the following questions by referring to the tables below. \\ cLO5 & course \\ Instructors: \\ compare different & \\ database models & \\ and implement a \\ database using \\ relational model \end{tabular} 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