Database system concept 7th
What is Exercise 2.18's solution?
Extracted text: 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) Figure 2.8 Schema of the university database.
Extracted text: 2.18 Write the following queries in relational algebra, using the university schema. а. Find the ID and name of each instructor in the Physics department. Further Reading 63 b. Find the ID and name of each instructor in a department located in the building "Watson". с. 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. е. Find the ID and name of each student who has not taken any course section in the year 2018.