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
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Question Posted: