Saturday, August 10, 2024

CRUD Operations

I made CRUD Operations on the database to proof that it works correctly:

The most important Query this database was made for is getting employee history:

Q6: 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.




Q5: How many employees are in each department?




Q1: Return a list of employees with Job Titles and Department Names:





Q2: Insert Web Programmer as a new job title:




No comments:

Post a Comment