Consider the Relations COLLEGE(CollegeID, Name, Location) and FACULTY(FacultyName, FacultyID, CollegeID). Which of the following is incorrect Relational Algebra Query equivalent to the following Query?
“Name all the faculties in college ‘TESTBOOK’. ”1
πCollegeID(FACULTY \(\Join\)(σNAME='TESTBOOK'(COLLEGE)))
2
πCollegeID(FACULTY \(\Join\)(σNAME='TESTBOOK'(FACULTY)))
3
πFacultyName(FACULTY \(\Join\)(σNAME='TESTBOOK'(COLLEGE)))
4
πFacultyName(FACULTY \(\Join\)(σNAME='TESTBOOK'(FACULTY)))