Question: 1 . ( 1 Point ) Write a relational algebra expression that returns the titles of all the courses with more than 3 credits from

1.(1 Point) Write a relational algebra expression that returns the titles of all the courses with more than 3 credits from the EE department. 2.(2 Points) Write a relational algebra expression that returns for each student, their name and the title of courses they have taken from their major, i.e., where the courses dept is equal to the students dept. 3.(2 Points) Write a relational algebra expression that returns the title and dept of courses that do not have any prerequisites. 4.(3 Points) Write a relational algebra expression that returns for the two students with sid 001 and 002, the cid of courses that only one of them has taken. 5.(4 Points) Write a relational algebra expression that returns for EVERY student, their sid , name and the number of failed credits as failedcredits . The failed credits for a student is the sum of credits of courses in which they have scored a gradepoint of less than 2.0.

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!