Question: Question 3. Given the following table definitions: Enrollment(stdld.crs Number, startate, finalirade) Student (sidid, sidName, address, age) Course ces Number, crs Name, description, course Weight) Provide

 Question 3. Given the following table definitions: Enrollment(stdld.crs Number, startate, finalirade)

Question 3. Given the following table definitions: Enrollment(stdld.crs Number, startate, finalirade) Student (sidid, sidName, address, age) Course ces Number, crs Name, description, course Weight) Provide appropriate relational algebra expressions for each of the following queries. 2. Find the name of comes in which that no student got a final grade more than 80 b. Find the name of students who mols in one or more course with the course Weight 2. c. Find the name of courses in which one or more students got final grade more than 80 d. Find the name of courses who have been enrolled by the same student in different dates. e. Find the name of students whose all enrolled courses have course Weight 1

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 Databases Questions!