this is to be solved using relational algebra

Exercise 1 (Relational Algebra) (25 points) Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise. Student (S_ID, s name, s degree: integer, advisorID, d_ID) Lecture ( ID, I name, 1 degree: integer, p_ID, d_ID) Register (S_ID _ID, score: integer, Semester) Professor (p ID, p_name, d_ID) Department (d ID, d name, address) 1. [5 points) Find the names of professors who have taught in every semester. 2. [5 points) List the names of lectures that the CISE department offers but that are taught by a professor whose department is not CISE. 3. [5 points) Find the names of students who got the highest score in the lecture 'Databases'. 4. [5 points) Find the names of students who have registered every lecture of the CISE department. 5. [5 points) Find the names of students who got more than 90 in the 'DB' lecture and less than 70 in the 'Algorithm lecture. Exercise 1 (Relational Algebra) (25 points) Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise. Student (S_ID, s name, s degree: integer, advisorID, d_ID) Lecture ( ID, I name, 1 degree: integer, p_ID, d_ID) Register (S_ID _ID, score: integer, Semester) Professor (p ID, p_name, d_ID) Department (d ID, d name, address) 1. [5 points) Find the names of professors who have taught in every semester. 2. [5 points) List the names of lectures that the CISE department offers but that are taught by a professor whose department is not CISE. 3. [5 points) Find the names of students who got the highest score in the lecture 'Databases'. 4. [5 points) Find the names of students who have registered every lecture of the CISE department. 5. [5 points) Find the names of students who got more than 90 in the 'DB' lecture and less than 70 in the 'Algorithm lecture