FunctionsPractice

FunctionsPractice - No Sales Edwards $110,958 $127,602 E...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Purpose: Class: Developer:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 3 (Parts 2 & 3): ACIS 2504 Marilyn Griffin
Background image of page 2
Employee ID Last Name First Name Birth Date Age end Hire Date 1001 Abner David 11/15/1977 M 6/20/2006 1002 Bateman Matthew 2/29/1976 M 8/3/1998 1003 Butler Susan 11/16/1967 F 8/13/1978 1004 Cannon Kenneth 8/15/1964 M 11/5/1997 1005 Conrad Michael 9/14/1955 M 12/25/2001 1006 Crockett Carol 11/19/1953 F 12/3/2004 1007 Davis Randall 7/15/1947 M 5/25/1980 1008 Edwards Minnie 3/8/1959 F 11/26/1991 1009 Jamie 5/2/1985 F 10/10/2001 1010 Franklin Margaret 11/25/1979 F 3/15/1977 Salary Range Grade Years for Vesting 10 $- A $25,000 B Raise Levels $50,000 C Sales 15% $70,000 D Finance 10% $90,000 E Other 5% $120,000 F $150,000 G $180,000 H
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Vested Department HR Rep Salary New Salary Salary Grade
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: No Sales Edwards $110,958 $127,602 E Sales Edwards $83,847 $96,424 D Marketing Edwards $40,816 $42,857 B Management Kelly $143,375 $150,544 F Product Development Kelly $74,665 $78,398 D Sales Kelly $43,374 $49,880 B Finance Kelly $42,106 Err:502 B Human Resources Zulkowski $90,228 $94,739 E Sales #N/A $28,625 $32,919 B Product Development Zulkowski $42,976 $45,125 B Total Salaries for Sales Dept. Total Using Structured References Dept. Rep Last Name Rep First Name Salary Range Grade A Edwards Minnie $- A C Kelly Chester $25,000 B E Zulkowski Mary $50,000 C G Mathis Adel $70,000 D P Kelly Chester $90,000 E T Edwards Minnie $120,000 F $150,000 G $180,000 H...
View Full Document

Page1 / 4

FunctionsPractice - No Sales Edwards $110,958 $127,602 E...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online