Write the following queries in relational algebra, using the university schema. a. Find the ID and name

Question:

Write the following queries in relational algebra, using the university schema.

a. Find the ID and name of each instructor in the Physics department.
b. Find the ID and name of each instructor in a department located in the building “Watson”.
c. Find the ID and name of each student who has taken at least one course in the “Comp. Sci.” department.

d. Find the ID and name of each student who has taken at least one-course section in the year 2018.
e. Find the ID and name of each student who has not taken any coursen section in the year 2018.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Question Posted: