Construct relation algebra statements answer for the following questions: Relations: Instructor (ID, name, salary,dept_n
Posted: Sat Nov 27, 2021 2:42 pm
questions: Relations: Instructor (ID, name, salary,dept_name) Course (id_inst,cours_id,course_name, description) 1. Retrieve the id, name, and salary of all instructor whose salary is greater than $50,000, using single expression and sequence expression
2. For each department find maximum salary and .minimum salary 3. Retrieve the name and salary of all instructor who teach the 'database' course name
Construct relation algebra statements answer for the following 2. For each department find maximum salary and .minimum salary 3. Retrieve the name and salary of all instructor who teach the 'database' course name