Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

See the Handout provided to you with the database (DB) queries and sample examples on how to set up criteria. The company wants to increase

See the Handout provided to you with the database (DB) queries and sample examples on how to set up criteria. The company wants to increase the salary of its employee using the following rules in the following EMPLOYEE database:

For New Salary of an employee: A female employee working as a Manager will get a 10.5% increase, while a male employee in the same position will get 9% increase (the company wants to take care of previous inequities in salaries!). All other employees get 5% increase if they have been with the company for more than 13 years, irrespective of their gender, otherwise their salary does not change. The salary column refers to the current salary of the employee; the Previous Salary column refers the salaried employee was hired at. A new Salary Column would be the new salary of the employee using the rules to provide more salary equity.

3. What percentage of employees are female employees hired after 1/7/2005?

Ex 1. What is the net new salary of employees with name starting with 2nd letter as D?

Ex 3. How many employees are there with third letter of their name as letter "l" and in Boston?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
See the Handout provided to you with the database (DB) queries and sample examples on how to set up criteria. N Company wants to increase the salary of its employee using following rules in the following EMPLOYEE database: For New Salary of an employee: 5 A female employee working as a Manager will get a 10.5% increase, while a male employee in the same position will get 9% increase (company wants to take care of previous inequities in salaries!). All other employees get 5% increase if they have been with company for more than 13 years, irrespective of their gender, otherwise their salary does not change. 9 Salary column refers to the current salary of the employee; Previous Salary column refers the salary employee was hired at. 10 New Salary Column would be the new salary of the employee using the rules to provide more salary equity. 11 Previous 12 Name Location Title Gender Hire Date Service Salary Salary New Salary 13 Rubin Boston Account Rep F 3/16/14 8.1 $45,000 $40,000 $ 45,000.00 14 Smith Atlanta Account Rep M 1/14/20 2.2 $65,000 $0 $ 65,000.00 15 Johnson Chicago Account Rep M 1/1/18 4.3 $47,500 $40,000 $ 47,500.00 16 Marder Chicago Account Rep F 6/15/07 14.8 $38,500 $35,000 $ 40,425.00 17 Manin Boston Account Rep 3/16/99 23.1 $49,500 $45,000 $ 51,975.00 18 James Chicago Account Rep 10/31/17 4.4 $42,500 $41,000 $ 42,500.00 19 Gillenson Miami Account Rep M 10/31/16 5.4 $55,000 $52,500 $ 55,000.00 20 Charles Boston Account Rep M 3/16/20 2.1 $40,000 so S 40,000.00 21 Elofsor Miami Account Rep F 4/23/95 27.0 $47,500 $45,000 $ 49,875.00 22 Tucci Miami Manager 1/25/07 15.2 $65,000 $57,550 $ 75,075.00 23 Milgrom Boston Manager M 3/16/13 9.1 $57,500 $55,000 $ 62,675.00 24 Adamson Chicago Manager F 3/16/12 10.1 $52,000 $45,000 $ 60,060.00 25 Coulter Atlanta Manager M 11/24/99 22.4 $100,000 $90,000 $ 109,000.00 26 Adams Atlanta Trainee M 1/9/10 12.3 $19,500 so $ 19,500.00 27 Brown Atlanta Trainee F 1/10/10 12.3 $18,500 So $ 18,500.00 28 Employee Queries LookUp info + ReadyQueries for Employee Worksheet How many employees are there in this database. 15 11 2 How many Managers work in Atlanta? Previous New 12 Name Location Title Gender Hire Date Service Salary Salary Salary 13 Atlanta Manager 10 3 What percentage of employees are female employees hired after 1/7/2005? Previous New 20 Name Location Title Gender Hire Date Service Salary Salary Salary 21 22 26 27 4 What is the average salary of managers earning between $40000 and $75000 (using New Salary)? Previous New New Name Location Title Gender Hire Date Service Salary Salary Salary Salary Manager >=40000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Theory And Analysis Text And Cases

Authors: Richard G Schroeder, Myrtle W Clark, Jack M Cathey

13th Edition

1119577772, 9781119577775

More Books

Students also viewed these Accounting questions