Data for the new EMPLOYEE table is shown below. This information is in the LABSDATA file.
EMPLOYEE NUMBER |
MANAGER EMPLOYEE NUMBER |
DEPARTMENT NUMBER |
JOB CODE |
LAST NAME |
FIRST NAME |
HIRE DATE |
BIRTH DATE |
SALARY AMOUNT |
1001 |
1003 |
401 |
412101 |
Hoover |
William |
76/06/18 |
50/01/14 |
25525.00 |
1002 |
1003 |
401 |
413201 |
Brown |
Alan |
76/07/31 |
44/08/09 |
43100.00 |
1003 |
801 |
401 |
411100 |
Trader |
James |
76/07/31 |
47/06/19 |
37850.00 |
1004 |
1003 |
401 |
412101 |
Johnson |
Darlene |
76/10/15 |
46/04/23 |
36300.00 |
1005 |
801 |
403 |
431100 |
Ryan |
Loretta |
76/10/15 |
55/09/10 |
31200.00 |
1006 |
1019 |
301 |
312101 |
Stein |
John |
76/10/15 |
53/10/15 |
29450.00 |
1007 |
1005 |
403 |
432101 |
Villegas |
Arnando |
77/01/02 |
37/01/31 |
49700.00 |
1008 |
1019 |
301 |
312102 |
Kanieski |
Carol |
77/02/01 |
58/05/17 |
29250.00 |
1009 |
1005 |
403 |
432101 |
Lombardo |
Domingus |
77/02/01 |
45/11/15 |
31000.00 |
1010 |
1003 |
401 |
412101 |
Rogers |
Frank |
77/03/01 |
35/04/23 |
46000.00 |
1011 |
801 |
402 |
421100 |
Daly |
James |
77/03/15 |
49/12/11 |
52500.00 |
1012 |
1005 |
403 |
432101 |
Hopkins |
Paulene |
77/03/15 |
42/02/18 |
37900.00 |
1013 |
1003 |
401 |
412102 |
Phillips |
Charles |
77/04/01 |
63/08/10 |
24500.00 |
1014 |
1011 |
402 |
422101 |
Crane |
Robert |
78/01/15 |
60/07/04 |
24500.00 |
1015 |
1017 |
501 |
512101 |
Wilson |
Edward |
78/03/01 |
57/03/04 |
53625.00 |
1016 |
801 |
302 |
321100 |
Rogers |
Nora |
78/03/01 |
59/09/04 |
56500.00 |
1017 |
801 |
501 |
511100 |
Runyon |
Irene |
78/05/01 |
51/11/10 |
66000.00 |
1018 |
1017 |
501 |
512101 |
Ratzlaff |
Larry |
78/07/15 |
54/05/31 |
54000.00 |
1019 |
801 |
301 |
311100 |
Kubic |
Ron |
78/08/01 |
42/12/11 |
57700.00 |
1020 |
1005 |
403 |
432101 |
Charles |
John |
78/10/01 |
49/06/21 |
39500.00 |
1021 |
1025 |
201 |
222101 |
Morrissey |
Jim |
78/10/01 |
43/04/29 |
38750.00 |
1022 |
1003 |
401 |
412102 |
Machado |
Albert |
79/03/01 |
57/07/14 |
32300.00 |
1023 |
1017 |
501 |
512101 |
Greene |
Peter |
79/03/01 |
62/10/29 |
26500.00 |
1024 |
1005 |
403 |
432101 |
Brown |
Allen |
79/05/01 |
54/01/16 |
43700.00 |
1025 |
801 |
201 |
211100 |
Short |
Michael |
79/05/01 |
47/07/07 |
34700.00 |