Relational Algebra Queries (Part 1)

DBMS: Relational Algebra Queries (Part 1)
Topics discussed:
Solved queries based on Relational Algebra:
1) Retrieve the names of all employees who work for the ‘Headquarters’ Department.
2) For every project located in ‘Stafford’, list the project number, controlling department, and the manager’s name.
3) Find the names of the employees who work on all the projects controlled by DNo = 3.
4) Make a list of project numbers for projects that involve an employee with LName = ‘Smith’, either as a worker or as a manager of the department that controls the project.

Follow Neso Academy on Instagram: @nesoacademy(https://bit.ly/2XP63OE)

Contribute: https://www.nesoacademy.org/donate

Memberships: https://bit.ly/2U7YSPI

Books: https://www.nesoacademy.org/recommend...

Website ► https://www.nesoacademy.org/
Forum ► https://forum.nesoacademy.org/
Facebook ► https://goo.gl/Nt0PmB
Twitter ►   / nesoacademy  

Music:
Axol x Alex Skrindo - You [NCS Release]

#DBMSByNeso #DBMS #RelationalAlgebraQueries