Question: There is no DML needed because we aren't writing the database commands, we are to write a RA query. Sorry for the confusion For this
There is no DML needed because we aren't writing the database commands, we are to write a RA query. Sorry for the confusion
For this question, assume the following relational schema. STUDENT(SID, Name, Dept, DOB, EMAIL) COURSE(CID, Name, Dept, Prof) TAKE(UUID, SID, CID, Semester) Given this, write the following queries in the Relational Algebra using only the basic operations of Cartesian Product (x), Selection (Co), Projection (11x), Union (U), and Difference (-). You may assume the renaming convention used in class (e.g. R.A) or use the p (renaming) operator as well. 4. Find the names of students who have taken at least two courses in the ECE department. 5. Find professors who have taught exactly three different) students named John. 6. Find departments that offered at least four courses during the semester Spring 2020. 7. Find students who have taken exactly the same courses. (Your query should return pairs of SID's.) I need this solution to check my answers. I will give a thumbs up for clear, correct work. Thanks For this question, assume the following relational schema. STUDENT(SID, Name, Dept, DOB, EMAIL) COURSE(CID, Name, Dept, Prof) TAKE(UUID, SID, CID, Semester) Given this, write the following queries in the Relational Algebra using only the basic operations of Cartesian Product (x), Selection (Co), Projection (11x), Union (U), and Difference (-). You may assume the renaming convention used in class (e.g. R.A) or use the p (renaming) operator as well. 4. Find the names of students who have taken at least two courses in the ECE department. 5. Find professors who have taught exactly three different) students named John. 6. Find departments that offered at least four courses during the semester Spring 2020. 7. Find students who have taken exactly the same courses. (Your query should return pairs of SID's.) I need this solution to check my answers. I will give a thumbs up for clear, correct work. Thanks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
