Using Relational Algebra

Relational Algebra 2) Use the following relations from the Research University Schema to answer the problems Person(SSN, Age, Name) Professor(SSN, Rank, Specialty) GraduateStudent(SSN, DegreeProgram, AdvisorSSN, DepartmentNumber) ProjectNumber, StartDate, EndDate, Budget, SponsorOrganizationName) below Department Number, Name, Abbreviation, MainOffice, ChairmanSSN) WorksForProfessorSSN, DepartmentNumber, TimePercentage) WorksOn(GraduateStudentSSN, ProjectNumber, SupervisingProfessorSSN) c) Retrieve the Name, Rank, and Specialty of all Professors who Work For more than one Department. You are not allowed to use the TimePercentage field for this question. ) Find the Name and Department of all Graduate Students who work on projects that do not employ any other graduate students