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 |