The Workforce database has four tables:
|
EmpNo |
Name |
DeptNo |
JobTitle |
Salary |
Yrs |
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 |
|
Received |
Due |
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
|