Database and tables from | Computer Science homework help

/in /by

  

1) Use the database and tables from last week’s assignment to write the following SQL queries .
a. Write a SQL query to increase all employees’ salaries with the selected EEO-1 classification by 10%. Use Update and include a join with Job_title.
b. Write a SQL query to increase all employees’ salaries by 5%. Use Update.
c. Write a SQL query that to select an employee from the Employee table and delete that employee.
Note: To delete or update a specific record you must specify the records primary key.
d. Deliverable: Save each SQL Statement you write in a Word file and post in your individual forum with your week 4 individual assignments.
 

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
Order Now

2) Use the database and tables from last week’s assignment to write SQL statements that do the following:
a) Calculate the average salary for all employees.
b) Calculate the maximum salaries for exempt and non-exempt employees.
Use Group By and include a join with Job_title
c) Calculate the maximum salary for all employees.
d) Calculate the minimum salaries for exempt and non-exempt employees.Use Group By and include a join with Job_title
e) Calculate the minimum salary for all employees.
f) Deliverable: Save each query you write in a Word file and post in your individual forum with your week 4 individual assignments.