Question: classroom ( building , room _ number, capacity ) department ( dept _ name, building, budget ) course ( course _ id , title, dept

classroom(building, room_number, capacity)
department(dept_name, building, budget)
course(course_id, title, dept_name, credits)
instructor(ID, name, dept_name, salary)
section(course_id, sec_id, semester, year, building, room_number, time_slot_id)
teaches(ID, course_id, sec_id, semester, year)
student(ID, name, dept_name, tot_cred)
takes(ID, course_id, sec_id, semester, year, grade)
advisor(s_ID, i_ID)
time_slot(time_slot_id, day, start_time, end_time)
prereq(course_id, prereq_id)
Write the following queries in relational algebra using the above 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 hasnot taken any course section in the year 2018.
Please explain the steps in creating the express!!!! Thank you!!!!

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 Programming Questions!