Opening the paper…
Database Management Systems, Quiz 1
Consider the following SQL query.
SELECT emp_name FROM employees WHERE salary > 20000Which among the following steps of query processing will convert the above query to the given relational algebra expression?
Consider the following SQL query. SELECT emp_name FROM employees WHERE salary > 20000 Which among the following steps of query processing will convert the above query to the given relational algebra expression? $$\Pi_{emp\_name}(\sigma_{salary>20000}(employees))$$ Figure from the original question paper E-R diagram: Student (student_num, student_name) with double line to enrolls diamond, arrow to Course (course_num, course_name)