There are four relations as follows: Student (id(PK), name,…
There are four relations as follows: Student (id(PK), name, dept_name(FK), gpa, major, phone, advisor_name) Department (dept_name(PK), building, budget) Takes (id(PK, FK), course_id(PK, FK), sec_id(PK, FK), semester(PK, FK), year(PK, FK) , grade) Course (course_id(PK), title, dept_name(FK), credit_hours) Note. PK = Primary key, and FK = Foreign key. Given: the number of records in table Student = 1,000. the number of records in table Course = 100. the number of records in table Takes = 5,000. the number of records in table Department = 10. Given Query: Find the name, phone, and gpa of students are in “CS” department and took the course’s title “Introduction to Biology” in Fall 2024 which is offered by “Biology” department and earned “A” grade. A.) Create the SQL Command for this query. (3 Points) B.) According to A.) what is the relational algebra expression for the SQL command? (3 Points) C.) According to B.) what is the optimize relational expression tree? (4 Points)