Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

What is management growth? What are its factors

Answered: 1 week ago