Consider the following relations concerning a driving school. The primary key of each relation in bold.
Student (st_id, class#, th_mark, dr_mark)
Student_Driving_Teacher (st_id, dr_t_name)
Teacher_Theory_Class (class#, th_t_name)
Teacher__vehicle (dr_t_name, license#)
Vehicle (license#, make, model, year)
A student takes one theory class as well as driving lessons and at the end of the sessions receives marks for theory and driving. A teacher may teach theory, driving or both. Write the following queries using SQL.
(i) Find the list of teachers who teach theory and give driving lessons on all the vehicles.
(ii) Find the list of students who are taught neither theory lessons nor driving lessons by T1 (Teacher)
(iii) Find the list of students who have better marks than S1 (Student) in both theory and driving
(iv) Find the list of teachers who can drive all the vehicles