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...








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 course
section in the year 2018.


Jun 08, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?