Question: Question 6 [ 7 points ] Write a query in Relational Algebra that returns the eID and last name of each course instructor who had

Question 6[7 points]
Write a query in Relational Algebra that returns the eID and last name of each course instructor who had a heavy teaching load for at least one term. A heavy term teaching load, for an instructor, is defined as teaching at least three different courses in that term.
Question 7[8 points]
Write a query in SQL that returns all the students who were on the Deans List at least once while they were at taking courses at the University. To be on the Deans List, a student must have obtained a grade greater or equal to 70 in all the courses they took that ter

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!