SQL Practice Exercise: Multiple relation querys Objective: Do relational join and subquery operations to combine or access data from multiple tables found in the University Database. 1. Join Queries: a. For each faculty member, produce a listing with faculty name, course code and the meetingTime for each course in which they are assigned. b. List the student id, student name and course code for students enrolled in 'CSCI233'. c. Do an equijoin to combine the student data with the corresponding enrollment data. Then expand the query to join Enrollment to Course. d. Find the names of students enrolled in courses that meet at the time 'TR12'. e. Do a left outer join of STUDENT and ENROLLMENT on sid to show all student names and the class codes in which they enrolled. f. Join the COURSE table to itself and project the value of faculty id for the course that is a prerequisite to 'CSCI340'. 2. Subqueries: a. Find the faculty name(s) assigned to the course 'CSCI270'. b. Get the student id and name for each student enrolled in a course. c. Find the name and major for students enrolled in the course 'CSCI233'. Compare your answer to the join query approach. d. Retrieve a list of courses in which the student named 'Childress' enrolled. First, write a query with nested query; then write a correlated subquery to list the courses. e. Find the names of students enrolled in courses that meet at the time 'MW11'. Compare your result to the join query. f. Do a correlative subquery with the NOT EXISTS operator to list the names of students not enrolled in any course.