|
EMPLOYEE |
|||||||||
|
Fname |
Minit |
Lname |
SSN |
BDate |
Address |
Sex |
Salary |
SuperSSN |
Dno |
|
John |
B |
Smith |
123456789 |
9-Jan-55 |
731 Fonden |
M |
3000 |
333445555 |
5 |
|
Franklin |
T |
Wong |
333445555 |
8-Dec-45 |
638 Voss |
M |
4000 |
888665555 |
5 |
|
Alicia |
J |
Zeleya |
999887777 |
19-Jul-58 |
3321 Castle |
F |
2500 |
987654321 |
4 |
|
Jennifer |
S |
Wallace |
987654321 |
20-Jun-31 |
291 Berry |
F |
4300 |
888665555 |
4 |
|
Ramesh |
K |
Narayan |
666884444 |
15-Sep-52 |
975 Fire Oak |
M |
3800 |
333445555 |
5 |
|
Joyce |
A |
English |
453453453 |
31-Jul-62 |
5631 Rice |
F |
2500 |
333445555 |
5 |
|
Ahmad |
V |
Jabbar |
987987987 |
29-Mar-59 |
980 Dallas |
M |
2500 |
987654321 |
4 |
|
James |
E |
Borg |
888665555 |
10-Nov-27 |
450 Stone |
M |
5500 |
null |
1 |
|
WORKS_ON |
||
|
ESSN |
PNo |
Hours |
|
123456789 |
1 |
32.5 |
|
123456789 |
2 |
7.5 |
|
666884444 |
3 |
40 |
|
453453453 |
1 |
20 |
|
453453453 |
2 |
20 |
|
333445555 |
2 |
10 |
|
333445555 |
3 |
10 |
|
333445555 |
10 |
10 |
|
333445555 |
20 |
10 |
|
999887777 |
30 |
30 |
|
999887777 |
10 |
10 |
|
987987987 |
10 |
35 |
|
987987987 |
30 |
5 |
|
987654321 |
30 |
20 |
|
987987987 |
20 |
15 |
|
888665555 |
20 |
null |
|
PROJECT |
|||
|
PName |
Pnumber |
PLocation |
DNum |
|
ProductX |
1 |
Bellaire |
5 |
|
ProductY |
2 |
Sugarland |
5 |
|
ProductZ |
3 |
Houston |
5 |
|
Computerization |
10 |
Stafford |
4 |
|
Reorganisation |
20 |
Houston |
1 |
|
Newbenefits |
30 |
Stafford |
4 |
|
DEPENDENT |
||||
|
ESSN |
DependentName |
Sex |
BDate |
Relationship |
|
333445555 |
Alice |
F |
5-Apr-76 |
Daughter |
|
333445555 |
Theodore |
M |
25-Oct-73 |
Son |
|
333445555 |
Joy |
F |
3-May-48 |
Spouse |
|
987987987 |
Abner |
M |
29-Feb-32 |
Spouse |
|
123456789 |
Michael |
M |
1-Jan-78 |
Son |
|
123456789 |
Alice |
F |
31-Dec-78 |
Daughter |
|
123456789 |
Elizabeth |
F |
5-May-57 |
Spouse |
|
DEPARTMENT |
|||
|
Dname |
Dnumber |
MgrSSN |
MgrStartDate |
|
Research |
5 |
333445555 |
22-May-78 |
|
Administration |
4 |
987654321 |
1-Jan-85 |
|
Headquarters |
1 |
888665555 |
19-Jun-71 |
|
DEPT_LOCATIONS |
|
|
Dnumber |
Dlocation |
|
1 |
Houston |
|
4 |
Stafford |
|
5 |
Bellaire |
|
5 |
Sugarland |
|
5 |
Houston |