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. 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
Get step-by-step solutions from verified subject matter experts
