Question: Exercise 2 Here is the relational database schema we consider. Student (di: NT, Name: STRNNG, Address: STRNNG, Status: SIRTNG) Professor (d: NNT, Name: STRNG, Deptid:

 Exercise 2 Here is the relational database schema we consider. Student

Exercise 2 Here is the relational database schema we consider. Student (di: NT, Name: STRNNG, Address: STRNNG, Status: SIRTNG) Professor (d: NNT, Name: STRNG, Deptid: INI) Course (Crsode: INT, Deptild: INT, GrsName: SIRNNG) Department(Deptid: NT, Name: STRNG) Teaching(CrscodeatNT.SemestersIrNTV, RrofidanN) Note: - Primary keys are underlined. - INT and STRNN are provided for guidance. - Grsegda is of the form CS121 or CSE114. - Semester is of the form F2030 for Fall 2030. Write the following queries in relationnl algebra, not SQL: - Names of the professors who taught in the history department (HIS Reptid). - Names of the professors who taught in Fall 1994 (F1994). - Ids of the professors who taught at lenst 2 courses in Fall 1999. - Names of the courses taught in Fall 1995 together with the names of the professors who taught them - Profids of the professors who taught all the courses of the CS department (Rapilid CS)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!