I need help on this one, I have a hard time to solve it. Thanks very much! Depar

Question

I need help on this one, I have a hard time to solve it. Thanks very much!

Department (D-code, D-Name, Chair-SSN) Course (D-code, C-no, Title, Units) Prereq (D-code, C-no, P-code, P-no) Class (Class-no, D-code, C-no, Instructor-SSN) Faculty (SSN, F-Name, D-Code, Rank) Student (Ssn, S-Name, Major, Status) Enrollment (Class-no, Student-Ssn) Transcript (Student-Ssn, D-Code, C-no, Grade)

Find instructors (Instructor-SSN, Insructor-name) who teach a class offered by a department other then their home department (in the Faculty table)?

Explanation / Answer

The query will retrieve the faculty name and number who teach the subject other than his department. The query will retrieve the instructor ssn and the name from both the class and Faculty table. Then it checks for the Department of the class currently going on with the faculty department code. If both are different then the corresponding rows will be retrieved oterwise it will not print.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.