Construct relation algebra statements answer for the following 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 questions: Relations: Instructor (ID, name, salary,dept_n
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Construct relation algebra statements answer for the following questions: Relations: Instructor (ID, name, salary,dept_n
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!