We have the following relations with sample tuples as shown below. The DB contains more tuples than shown so your answer must work for general case STUDENT(STUD\#, STUD_NAME, MAJOR, GPA) TEACHER(FACULTY\#, DEPT, TEACHERNAME) ENROLLMENT(STUD\#, COURSE\#, GRADE) RESPONSIBILITY(FACULTY\#, COURSE\#) Student Teacher Responsibility Enrollment Translate the queries into the relational algebra (you do not have to show the result and you may assume that attributes with the same name are based on same domain) Use the following syntax (as in Assignment 1) - examples: SELECT Example of syntax you are expected to use: R1 := SELECT order WHERE order\# =1234 PROJECT - Example of syntax you are expected to use: R1 := PROJECT customer OVER (name, address) JOIN -Example of syntax you are expected to use: R1:= JOIN customer, order OVER cust\# DIVIDE - Example of syntax you are expected to use: R1 := DIVIDE Completed BY DBProject RELATIONAL ALGEBRA EXAM QUESTIONS: 1. What are the names ,IDs, and majors of students who are enrolled in course taught by teachers whose name is 'Joseph'? 2. What are the names, student ids, and GPAs of students who are enrolled in courses that are the responsibility of teachers in the CE department and who h grades of ' B ' in those courses? 3. What are the names of teachers who teach students enrolled in CE major