Answered step by step
Verified Expert Solution
Question
1 Approved Answer
student ID dept nante akes ID course id sec id sennester ear tot cred rade sectio17 course department advisor itle dept name credits semester ET
student ID dept nante akes ID course id sec id sennester ear tot cred rade sectio17 course department advisor itle dept name credits semester ET building OO no fine siot id building budget time slot end tim instructor ID depi nanme prereg classroo eaches ID sec id salary Express answers to 3-9 in relational algebra. Your queries should NOT include unneeded relations. a. Find the ID's of all instructors who have taught or are teaching a course from a different department than the one to which they are assigned. For example, the result would include Electrical Engineering professors who teach Computer Science courses. (10 points) Find the names of all instructors who have taught the same course more than once. (10 points) C Find the titles of all courses that have been taught in every semester/year. (10 points) d. Rewrite your answer to problem 6 using only fundamental operations. (10 points) e. List all buildings/rooms in which a Computer Science class has NOT been taught. (10 points) f. List all of the names of all instructors who were once students at the university. Note: you will need to make an assumption in order to write this query. State your assumption. (10 points) student ID dept nante akes ID course id sec id sennester ear tot cred rade sectio17 course department advisor itle dept name credits semester ET building OO no fine siot id building budget time slot end tim instructor ID depi nanme prereg classroo eaches ID sec id salary Express answers to 3-9 in relational algebra. Your queries should NOT include unneeded relations. a. Find the ID's of all instructors who have taught or are teaching a course from a different department than the one to which they are assigned. For example, the result would include Electrical Engineering professors who teach Computer Science courses. (10 points) Find the names of all instructors who have taught the same course more than once. (10 points) C Find the titles of all courses that have been taught in every semester/year. (10 points) d. Rewrite your answer to problem 6 using only fundamental operations. (10 points) e. List all buildings/rooms in which a Computer Science class has NOT been taught. (10 points) f. List all of the names of all instructors who were once students at the university. Note: you will need to make an assumption in order to write this query. State your assumption. (10 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started