Specify the following queries in SQL on the database state shown below.

To get the Solution, drop an email at [email protected]
Please feel free to send us your queries at: [email protected]
Problem Statement

. Specify the following queries in SQL on the database state shown below. 1. Retrieve the names of all senior students majoring in ‘cs’ (computer science). 2. Retrieve the names of all courses taught by Professor King in 2007 and 2008. 3. For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section. 4. Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. 5. Insert a new student, ≦ Johnson’, 25, 1, ‘Math’>, in the database. 6. Change the class of student ‘Smith’ to 2 . 7. Insert a new course, ≦ ‘Knowledge Engineering’, ‘cs4390’, 3, ‘cs’>. 8. Delete the record for the student whose name is ‘Smith’ and whose stu- dent number is 17. STUDENT GRADF RFPORT PREREOUISITE

To get the Solution, drop an email at [email protected]
Please feel free to send us your queries at: [email protected]