Write SQL statements to do the following on the database schema shown below in the picture. a) Insert a new record in the course table with the following data values course number = 'COSC4390' course...

Write SQL statements to do the following on the database schema shown below in the picture.

1. a) Insert a new record in the course table with the following data values

course number = 'COSC4390'

course name = 'Knowledge Engineering'

course credit hours= ‘3’

department = ’COSC'>.

1. b) Change the class of student 'Ahmed' to 4.


2. c) Delete the record of the student whose name is 'Ahmed' and his number is 22.

Extracted text: STUDENT Name Student_number Class Major COURSE Course_name Course_number Credit_hours Department