Farah Styles IR Using the following database formulate SQL statements to satisfy what is requested: Note: Primary keys appear in bold and underlined and foreign key in italics COURSE CourseNo CourseName NoofCredits) SECTION CourseNo SectionNo Days.Offered, TimesOffered) LECTURER LecturerNo, Lesl. Name, lecFName) TEACHING CourseNo", Section No*. Lecturer No*) Note: A section of a course might be jointly taught by more than one lecturer. Select ANY 10 of the following requests to express using SQL. a) For the sections scheduled for Wednesday, 18:00-21:00 show the CourseNo SectionNo, and LecturerNo. Use subqueries. b) Append records in the LECTURER table from a PART TIME table which has the same structure. c) Remove from the TEACHING table all courses taught by the faculty with LechName being "loannou". d) Produce a list with lecturer details (Lecturer No, LeclName, LecFName) along with the courses they teach (CourseNo Section No. Include in the list any lecturers not assigned to any courses. Show the output in order of LecLName. (Use OUTER JOIN) e) Create a view by the name CSCourses to keep the timetable of all of the COMP courses. (Hint: the CourseNo must start with COMP). AaBbcel AaBCC AaBb Aalbel AaBb AaBbc AaBbce Amchanbe Anbc 1 Normal 1 Normal Title 1 No Spac1 Sender Heading 1 Heading 2 Headings Heading Paragrap Styles 1) Write a correlated subquery to check if by mistake two records were created for the same lecturer. Check for the Lecturer No to be different but the Lect Name and LesFName to be the same. g) Update the name of the course with CourseNo, "COMP-333" to "Advanced Databases". h) Create the table COURSE specifying a constraint for the primary key. i) Remove all of the data from the TEACHING table to set it up for the new semester. Do not remove the table. i) All of the data and other relationships with the TEACHING table have been removed. You only need to delete the table of TEACHING. k) Add the field Lecturer No INT NULL in the table COURSE to keep the faculty responsible for the course