Question: ( 1 2 points ) Take into consideration the following schema and write the Relational Algebra statement for the following: Faculty ( facId , name,
points Take into consideration the following schema and write the Relational Algebra statement for the following:
Faculty facId name, department, rank
Class classNo factId, schedule, room
Student stuId lastName, firstName, major, credits
Enroll stuId classNo, grade
Write the Relational Algebra statement for the following:
a Find all information in the Student table about student with stuID Sio
b Find classes that meet in room C
c Find all math majors who have more than credits.
d Find all the different majors that students have.
e Find the rooms where each faculty member teaches.
f Show the names and IDs of all CS majors.
points Using the following two tables, display the resulting relations from the specified set operations.
MainFaculty
tablefacIDName,Department,RankFAdams,Art,ProfessorFTanaka,CSCInstructorFSmith,CSCProfessor
BranchFaculty
tablefacIDName,Department,RankFAdams,Art,ProfessorFByrne,Math,AssistantFSmith,History,AssociateFSmith,CSCProfessor
a MainFaculty BranchFaculty
b MainFacutly BranchFaculty
c MainFaculty BranchFaculty
d BranchFaculty MainFaculty
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
