Answer Happy

Relational Algebra Exercises 2 Write the relational algebra expressions for the following queries. Use the database schema given below. 1. Find the total number of students of the "Computer Engineering” department. 2. Find the total number of students by each department. 3. Find the department with the highest budget. 4. Find the instructors who taught all courses offered by the "Software Engineering“ department. 5. Find the list of courses taught in Fall 2020 but not in Fall 2021. 6. Find the names of the students who took “A” from "SEN2104” in Spring 2020. 7. Find the names of the students who took “SEN2104” and “MAT3012" in Spring 2020. Course Student PK stu_id name FK dept_name Department PK dept name building budget PK course_id title FK dept_name credits Takes PK, FK Stuid PK, FK course_id PK, FK sec_id PK, FK semester PK, FK year grade Advisor Instructor PK ins id name FK dept_name salary FK stu_id FK ins_id Section PK, FK course_id PK sec_id PK semester PK year room FK insid