Summary
Keywords
Full Transcript
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: http://bit.ly/3EpZgBD Memberships: https://bit.ly/2U7YSPI Discord: https://bit.ly/3HiGtJr WhatsApp: https://whatsapp.com/channel/0029Va9B1Bq4tRru0nqgtx3h Books: https://bit.ly/4cZYQil Website ► https://www.nesoacademy.org/ App ► https://play.google.com/store/apps/details?id=org.nesoacademy Facebook ► https://www.facebook.com/nesoacademy Twitter [X] ► https://x.com/nesoacademy Music: Axol x Alex Skrindo - You [NCS Release] #DBMSByNeso #DBMS #RelationalAlgebraQueries
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
