For this project, a database was designed, built, and populated for a Human Resources Department at the imaginary TECH ABC Corp. An HR manager, gave us a list of business requirements and the database was designed with best practices.
Tech ABC Corp saw explosive growth with a sudden appearance onto the gaming scene with their new AI-powered video game console. As a result, they have gone from a small 10 person operation to 200 employees and 5 locations in under a year. HR is having trouble keeping up with the growth, since they are still maintaining employee information in a spreadsheet. While that worked for ten employees, it has becoming increasingly cumbersome to manage as the company expands.
As such, the HR department has tasked you, as the new data architect, to design and build a database capable of managing their employee information.
Question 6 - Write a query that returns current and past jobs (include employee name, job title, department, manager name, start and end date for position) for employee Toni Lembeck.