find business applications of online analytical processing (OLAP). Why do companies use OLAP? What is the connection between OLAP and databases?
|
Record |
Last |
First |
Social Security Number |
Dept |
Pay |
Over |
|
Number |
Name |
Name |
Rate |
time |
||
|
1 |
ADCOX |
NORMAN |
901795336 |
1 |
6.5 |
Yes |
|
2 |
KOZAR |
LINDA |
412935350 |
1 |
6.5 |
Yes |
|
3 |
MCLEAN |
KAY |
405751308 |
1 |
7.5 |
No |
|
4 |
CUNNINGHAM |
TOM |
919782417 |
3 |
7.5 |
Yes |
|
5 |
DANIELS |
PATRICIA |
517351609 |
3 |
5.5 |
Yes |
|
6 |
MCGUIRE |
ANNE |
201891647 |
3 |
5.5 |
Yes |
|
7 |
REEDER |
BRENDA |
619294493 |
3 |
5.5 |
Yes |
|
8 |
BLOOM |
BRENDA |
513321592 |
4 |
6.25 |
Yes |
|
9 |
DAVIS |
DENISE |
517351608 |
4 |
5.5 |
Yes |
|
10 |
DUFFY |
LESLIE |
314532409 |
4 |
8.5 |
No |
|
11 |
HARPER |
LINDA |
615824130 |
4 |
5.75 |
Yes |
|
12 |
MORGAN |
MEREDITH |
704563903 |
4 |
6.25 |
Yes |
|
13 |
WELSH |
KAREN |
216253428 |
4 |
8.25 |
No |
|
14 |
CHAPIN |
GEORGE |
203767263 |
5 |
7.5 |
Yes |
|
15 |
FINN |
JOHN |
715386721 |
5 |
6.25 |
Yes |
|
16 |
HALPIN |
MARSHA |
913541871 |
5 |
6.5 |
Yes |
|
17 |
LAURIN |
PHILIP |
514484631 |
5 |
6.5 |
Yes |
|
18 |
MIAGLIO |
PEGGY |
414224972 |
5 |
6.25 |
Yes |
|
19 |
TURNER |
BRENDA |
713589164 |
5 |
8.5 |
No |
|
20 |
ZORICH |
MILDRED |
504455827 |
5 |
6.5 |
Yes |
|
Personnel File |
|||||
|
Employee |
Score on Aptitude |
Department |
Current |
||
|
Number |
Test |
ID |
Pay Rate |
Sex |
|
|
BAKER, JEFFREY L. |
1692 |
73 |
A |
$7.50 |
M |
|
BARRETT, RAYMOND G. |
3444 |
53 |
B |
7.45 |
M |
|
BLISS, DONALD W. |
6713 |
55 |
D |
6.80 |
M |
|
BOWERS, PAUL D. |
2084 |
42 |
B |
5.90 |
M |
|
BUCHANAN, CINDY |
3735 |
41 |
E |
7.80 |
F |
|
CHEUNG, WAI KONG |
8183 |
55 |
C |
7.80 |
F |
|
CONRAD, MARK E. |
8317 |
58 |
D |
9.60 |
M |
|
DAILY, REBECCA E. |
2336 |
45 |
D |
8.90 |
F |
|
DRISCOLL, DAVID M. |
5210 |
47 |
D |
7.70 |
M |
|
ERICKSON, KURT N. |
2217 |
53 |
B |
8.50 |
M |
|
FRANTZ, HEIDI L. |
6390 |
55 |
A |
6.90 |
F |
|
GARROW, SCOTT D. |
8753 |
61 |
A |
7.40 |
M |
|
HARDENBROOK, LISA A. |
7427 |
40 |
C |
6.70 |
F |
|
JACKSON, GREG W. |
4091 |
67 |
D |
8.90 |
M |
|
LANGLEY, JERRY W. |
3262 |
86 |
E |
9.40 |
M |
|
LUBINSKI, TRAVIS M. |
3865 |
37 |
D |
7.50 |
M |
|
LYNCH, SHERENE D. |
7857 |
66 |
D |
8.90 |
F |
|
MARKHAM, KYLE R. |
6766 |
62 |
A |
7.90 |
M |
|
MCGUIRE, TANA B. |
4052 |
55 |
A |
9.20 |
F |
|
MONACH, SHERI L. |
8082 |
48 |
B |
9.10 |
F |
|
MOORE, MICHAEL S. |
2431 |
67 |
E |
8.50 |
M |
|
NELSON, JOHN R. |
5873 |
46 |
B |
7.40 |
M |
|
PAPEZ, PETER M. |
7799 |
41 |
E |
8.30 |
M |
|
PETTINARI, DARIN M. |
1222 |
56 |
B |
8.40 |
M |