A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, office locations, salary scales, and which company vehicles their employees drive.
The application must keep track of all the positions at the firm, the employees filling these positions, the offices for these positions which may have more than one employee, the salary scales for these positions, and the company vehicles assigned to these positions.
Hint: There are seven tables in the solution. For each entity, there is a table. Take a look at the last sentence for 5 entities. when there are many to many relationships, we need bridge tables.
Submit the HR database ERD, SQL to create and populate tables and answers to these queries:
1. Show all employees with vehicles, locations, positions, and salary
2. Show all for employee with highest salary
3. Show all for employees with 'A' in their first name.
4. Show how many employees
5. Show average salary.
36 freelancer đang chào giá trung bình $29 cho công việc này
hi sir, i will create the table creation scripts and insert scripts to populate data and will make the erd and will give queries for all 5 points, ready to start now and will create in 6 hours. thanks