Write a representation of the following in relational algebr

Write a representation of the following in relational algebra
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10
Write a representation of the following in relational algebra
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10

Solution

select * from employees as e,branches as b where e.employee_id= b.branch and e.employee_id=10

 Write a representation of the following in relational algebra 2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10 Wri

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site