Consider the following relational schema for a database that keeps track of student enrollment in courses and the books adopted for each course:

STUDENT $($Sno$,$ Name, Major, Class$)$

COURSE $($Course#$,$ Cname, Dept, credit$\_$hours$)$

SECTION $($Section#$,$ Course#$,$ Semester, Year, Instructor$)$

GRADE$\_$REPORT $($Sno$,$ Section#$,$ Grade$)$

PREREQUISITE $($Course#$,$ Prerequisite#$)$

i$.$ Retrieve the names and major of all students who secured Grade$-$A

ii$.$ Retrieve the names and major departments of all students who do not have a grade of $A$ in any of their courses.

iii. Retrieve the names of all courses taught by Professor King in $2007$ and $2008.$

iv$.$ For each section taught by Professor King, retrieve the course number, semester, year, and number of students in this section.

v$.$ Delete the record for the student whose name is 'Smith' and student number is $17.$