Question: Question 1: Consider the following database schema STUDENT COURSE Write an appropriate Relational Algebra expression to any (4) of the following questions: A. Find the

 Question 1: Consider the following database schema STUDENT COURSE Write an
appropriate Relational Algebra expression to any (4) of the following questions: A.
Find the names of all the students enrolled in course PHYS331 B.

Question 1: Consider the following database schema STUDENT COURSE Write an appropriate Relational Algebra expression to any (4) of the following questions: A. Find the names of all the students enrolled in course PHYS331 B. List all the students (sid and name) who got a grade C C. Find the IDs of all the students (sid). whose grade in 'EE201' is grater than their grade in CS496 D. List the titles of all the courses that student Bob' did not take. E. List all the courses ID and for each course retun the number of courses it has as a prerequisite. F. List the student ID and Name and the average grades for each course he/she has taken. G. List all CS department coursers Hust SID, Name of every student in CS Department. . Find the list of students who have taken course EE201, and got a grade 'A Find all the EE or PHYS students (sidand name) that have taken all the courses offered by the CS department

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!