Question: 1 . Write a relational algebra expression that returns the number of students for each course ( use course _ id ) per year. 2
Write a relational algebra expression that returns the number of students for each course use courseid per year.
Write a relational algebra expression that returns the title of Computer Science CS courses and their corresponding room number where these courses are taught in classrooms.
Write a relational algebra expression that returns the department names and their corresponding budgets where the total number of students is larger than for the departments.
Write a relational algebra expression that returns the student ID and name of the students whose total credit is higher than the average total credits of all students.
Write a relational algebra expression that returns the course ID and title of the courses that are taught by instructors with the highest salary. Hint: it may be useful to create variables to reduce the complexity of the final relational algebra expression
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
