The Workforce database has the following tables:
- Employee table
- Department table
- Project table
- Charges table
EmpNo | Name | DeptNo | JobTitle | Salary | Yrs Exp | DOB | Sex | Race | Mstat | EdLev | HCap |
---|---|---|---|---|---|---|---|---|---|---|---|
10001 | Peterson J | 100 | Payroll Ck | 25,000.00 | 5 | Mar 27, 1942 | M | C | M | 12 | 0 |
10002 | Moffit H | 100 | Recruiter | 35,000.00 | 3 | Nov 16, 1945 | F | B | W | 18 | 0 |
10003 | Leidner P | 300 | Secretary | 23,000.00 | 13 | Jul 12, 1948 | F | C | M | 16 | 0 |
10004 | Smith T | 500 | Engineer | 42,000.00 | 10 | Oct 31, 1951 | M | C | M | 18 | 0 |
10006 | Kemper R | 600 | Assembler | 29,000.00 | 7 | Sep 12, 1947 | M | C | M | 12 | 0 |
10007 | Aguilar J | 600 | Manager | 45,000.00 | 11 | Jul 09, 1949 | M | S | M | 16 | 0 |
10008 | Phan A | 300 | Vice Pres | 55,000.00 | 12 | Jun 07, 1947 | F | A | M | 18 | 0 |
10009 | Marston A | 500 | Secretary | 22,000.00 | 12 | Jun 07, 1947 | F | A | M | 18 | 0 |
10010 | Reed C | 500 | Technician | 30,000.00 | 4 | Apr 08, 1949 | M | C | D | 16 | 0 |
10011 | Chin M | 100 | Controller | 38,000.00 | 11 | Nov 29 1955 | F | A | M | 16 | 0 |
10012 | Watson L | 500 | Vice Pres | 56,000.00 | 8 | Oct 03, 1943 | M | C | S | 20 | 0 |
10013 | Regan R | 600 | Purchaser | 44,000.00 | 10 | Oct 20, 1948 | F | C | M | 16 | 0 |
10014 | Inglis C | 500 | Tech Writer | 34,000.00 | 5 | Mar 07, 1938 | M | C | S | 16 | 0 |
10015 | Omura H | 500 | Programmer | 40,000.00 | 8 | Apr 24, 1954 | M | A | S | 16 | 0 |
10016 | Carter J | 500 | Engineer | 44,000.00 | 20 | Mar 12, 1935 | M | C | M | 20 | 0 |
10017 | Greene W | 100 | Payroll Ck | 32,500.00 | 15 | Nov 27, 1955 | M | N | M | 16 | 0 |
10018 | Russell S | 300 | President | 65,000.00 | 25 | Jun 05, 1932 | M | B | D | 16 | 0 |
10019 | Newman P | 600 | Test Tech | 28,600.00 | 6 | Aug 29 1956 | F | C | M | 12 | 0 |
10020 | Brangle B | 700 | Salesperson | 30,000.00 | 5 | Oct 15, 1947 | F | C | S | 16 | 0 |
10021 | Smith T | 700 | Manager | 45,000.00 | 10 | Jul 29, 1946 | F | B | S | 16 | 0 |
10022 | Clements D | 700 | Salesperson | 38,000.00 | 9 | Aug 23, 1944 | M | C | M | 16 | 0 |
DeptNo | DeptName | Loc | MgrNo |
---|---|---|---|
100 | Administration | NYC | 10011 |
300 | Exec Office | NYC | 10018 |
500 | Engineering | ATL | 10012 |
600 | Manufacturing | CHI | 10007 |
700 | Marketing | NYC | 10021 |
Project Id | Project Description | Received Date | Due Date | Compl Date |
---|---|---|---|---|
AP1-0001 | A/P Payable DB Design | 82/08/09 | 83/04/10 | 83/04/10 |
AP1-0002 | A/P Payable Online System | 82/08/09 | 83/04/10 | 83/04/21 |
AP1-0003 | A/P Payable Batch System | 82/08/09 | 83/04/10 | 83/04/21 |
AP2-0001 | A/P Payable DB Design | 82/08/09 | 83/04/10 | 83/04/10 |
AP2-0002 | A/P Payable Online System | 82/08/09 | 83/04/10 | 83/04/10 |
AP2-0003 | A/P Payable Batch System | 82/08/09 | 83/04/10 | 83/04/10 |
AR1-0001 | A/R RECV Data Base Design | 82/08/09 | 83/04/10 | 83/04/21 |
AR1-0002 | A/R RECV Online System | 82/08/09 | 83/04/10 | 83/04/10 |
AR1-0003 | A/R RECV Batch System | 82/08/09 | 83/04/10 | 83/04/20 |
AR2-0001 | A/R RECV Data Base Design | 82/08/09 | 83/04/10 | 83/04/10 |
AR2-0002 | A/R RECV Online System | 82/08/09 | 83/04/10 | 83/04/10 |
AR2-0003 | A/R RECV Batch System | 82/08/09 | 83/04/10 | 83/04/10 |
ENG-0001 | Design Widget Boards | 78/01/02 | 78/12/31 | 78/12/06 |
ENG-0002 | Design Widget Pwr Supply | 78/01/02 | 79/07/19 | 78/08/08 |
ENG-0003 | Design Widget Frame | 78/01/02 | 80/10/27 | 81/05/05 |
ENG-0004 | Assemble and Test Widget | 81/04/10 | 81/10/27 | 81/10/26 |
OE1-0001 | O/E Data Base Design | 82/11/21 | 83/10/27 | 83/10/27 |
OE1-0002 | O/E Online System | 82/11/21 | 83/10/27 | 83/10/27 |
OE1-0003 | O/E Batch System | 82/11/21 | 83/10/27 | 83/10/27 |
OE2-0001 | O/E Data Base Design | 82/11/21 | 83/10/27 | 83/10/27 |
OE2-0002 | O/E Online System | 82/11/21 | 83/10/27 | 83/11/10 |
OE2-0003 | O/E Batch System | 82/11/21 | 83/10/27 | 83/11/15 |
PAY-0002 | Payroll File Maintenance | 83/01/01 | 83/12/31 | 84/01/31 |
PAY-0001 | Payroll System Data Entry | 83/01/01 | 83/12/31 | 84/01/10 |
Employee Id | Project Id | Week Ending | Hours |
---|---|---|---|
10001 | PAY-0002 | 83/10/21 | 34.5 |
10001 | PAY-0001 | 83/11/18 | 4.5 |
10001 | PAY-0001 | 83/09/30 | 5.0 |
10002 | OE1-0001 | 83/03/11 | 12.0 |
10002 | OE1-0001 | 83/04/15 | 33.5 |
10003 | OE1-0001 | 83/03/18 | 23.0 |
10003 | OE1-0001 | 83/02/25 | 10.5 |
10004 | ENG-0003 | 83/11/18 | 40.0 |
10004 | ENG-0002 | 83/07/29 | 53.0 |
10010 | AP1-0002 | 83/02/18 | 10.0 |
10010 | EO1-0001 | 83/10/07 | 10.0 |
10010 | AR1-0001 | 83/02/18 | 12.5 |
10014 | OE1-0001 | 83/01/28 | 30.0 |
10014 | OE1-0001 | 83/01/21 | 30.5 |
10014 | OE1-0002 | 83/01/14 | 20.0 |
10015 | AP1-0001 | 83/02/18 | 30.5 |
10015 | AR1-0002 | 83/02/25 | 24.0 |
10016 | ENG-0003 | 83/02/25 | 2.5 |
10016 | ENG-0002 | 83/01/14 | 32.0 |
10016 | ENG-0002 | 83/05/20 | 32.0 |
10017 | PAY-0001 | 83/08/26 | 33.0 |
10017 | PAY-0001 | 83/04/15 | 37.0 |
10019 | AR1-0003 | 83/02/04 | 28.0 |
10019 | AP1-0003 | 83/02/11 | 20.5 |