this is my data base class. please question 4 parts a-d. please answer asap and I promise to give you a thumbs up

4. (20 points) Queries Consider the following schema of an administrative database for college personnel: PROFESSOR(SSN, FNAME, LNAME, RANK, SALARY) DEPARTMENT NAME, OFFICE, PHONE, CHAIRID) MEMBER(DEPT NAME, PROF ID) Primary keys are underlined in the schema definition. Foreign keys are as follow references schema SSN of PROFESSOR SSN of PROFESSOR NAME of DEPARTMENT field in schema CHAIRIDDEPARTMENT PROF ID MEMBER DEPT NAME MEMBER Write the following queries in Relational Algebra (a) Retrieve full name (first and last) and rank of each professor who earns more than 40000 dollars in salary