Tabelle: PROJECT (Tabellenbeschreibung)



Spaltenname
Datentyp
Länge
Genauigkeit
Kommastellen
Nullable
PROJNO
CHARACTER
6
-
-
Not Null
PROJNAME
VARCHAR
 24
-
-
Not Null
DEPTNO
CHARACTER
3
-
-
Not Null
RESPEMP
CHARACTER
6
-
-
Not Null
PRSTAFF
DECIMAL
5
5
2
Null
PRSTDATE
DATE
-
-
-
Null
PRENDATE
DATE
-
-
-
Null
MAJPROJ
CHARACTER
6
-
-
Null


Tabelle: PROJECT (Dateninhalte)



PROJNO PROJNAME DEPTNO RESPEMP PRSTAFF PRSTDATE PRENDATE MAJPROJ
AD3100 ADMIN SERVICES D01 000010 6.50 1982-01-01 1983-02-01  
AD3110 GENERAL ADMIN SYSTEMS D21 000070 6.00 1982-01-01 1983-02-01 AD3100
AD3111 PAYROLL PROGRAMMING D21 000230 2.00 1982-01-01 1983-02-01 AD3110
AD3112 PERSONNEL PROGRAMMING D21 000250 1.00 1982-01-01 1983-02-01 AD3110
AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
IF1000 QUERY SERVICES C01 000030 2.00 1982-01-01 1983-02-01  
IF2000 USER EDUCATION C01 000030 1.00 1982-01-01 1983-02-01  
MA2100 WELD LINE AUTOMATIOND01 000010 12.00 1982-01-01 1983-02-01  
MA2110 W L PROGRAMMING D11 000060 9.00 1982-01-01 1983-02-01 MA2100
MA2111 W L PROGRAM DESIGN D11 000220 2.00 1982-01-01 1982-12-01 MA2110
MA2112 W L ROBOT DESIGN D11 000150 3.00 1982-01-01 1982-12-01 MA2110
MA2113 W L PROD CONT PROGS D11 000160 3.00 1982-02-15 1982-12-01 MA2110
OP1000 OPERATION SUPPORT E01 000050 6.00 1982-01-01 1983-02-01  
OP1010 OPERATION E11 000090 5.00 1982-01-01 1983-02-01 OP1000
OP2000 GEN SYSTEMS SERVICES E01 000050 5.00 1982-01-01 1983-02-01  
OP2010 SYSTEMS SUPPORT E21 000100 4.00 1982-01-01 1983-02-01 OP2000
OP2011 SCP SYSTEMS SUPPORT E21 000320 1.00 1982-01-01 1983-02-01 OP2010
OP2012 APPLICATIONS SUPPORT E21 000330 1.00 1982-01-01 1983-02-01 OP2010
OP2013 DB/DC SUPPORT E21 000340 1.00 1982-01-01 1983-02-01 OP2010
PL2100 WELD LINE PLANNING B01 000020 1.00 1982-01-01 1982-09-15 MA2100


Tabelle: STAFF (Tabellenbeschreibung)



Spaltenname
Datentyp
Länge
Genauigkeit
Kommastellen
Nullable
ID
SMALLINT
-
-
-
Not Null
NAME
VARCHAR
9
-
-
Null
DEPT
SMALLINT
-
-
-
Null
JOB
CHARACTER
5
-
-
Null
YEARS
SMALLINT
-
-
-
Null
SALARY
DECIMAL
7
7
2
Null
COMM
DECIMAL
7
7
2
Null


Tabelle: STAFF (Dateninhalte)



ID NAME DEPT JOB YEARS SALARY COMM
10 Sanders 20 Mgr 7 18357.50  
20 Pernal 20 Sales 8 18171.25 612.45
30 Marenghi 38 Mgr 5 17506.75  
40 O'Brien 38 Sales 6 18006.00 846.55
50 Hanes 15 Mgr 10 20659.80  
60 Quigley 38 Sales   16808.30 650.25
70 Rothman 15 Sales 7 16502.83 1152.00
80 James 20 Clerk   13504.60 128.20
90 Koonitz 42 Sales 6 18001.75 1386.70
100 Plotz 42 Mgr 7 18352.80  
110 Ngan 15 Clerk 5 12508.20 206.60
120 Naughton 38 Clerk   12954.75 180.00
130 Yamaguchi 42 Clerk 6 10505.90 75.60
140 Fraye 51 Mgr 6 21150.00  
150 Williams 51 Sales 6 19456.50 637.65
160 Molinare 10 Mgr 7 22959.20  
170 Kermisch 15 Clerk 4 12258.50 110.10
180 Abrahams 38 Clerk 3 12009.75 236.50
190 Sneider 20 Clerk 8 14252.75 126.50
200 Scoutten 42 Clerk   11508.60 84.20
210 Lu 10 Mgr 10 20010.00  
220 Smith 51 Sales 7 17654.50 992.80
230 Lundquist 51 Clerk 3 13369.80 189.65
240 Daniels 10 Mgr 5 19260.25  
250 Wheeler 51 Clerk 6 14460.00 513.30
260 Jones 10 Mgr 12 21234.00  
270 Lea 66 Mgr 9 18555.50  
280 Wilson 66 Sales 9 18674.50 811.50
290 Quill 84 Mgr 10 19818.00  
300 Davis 84 Sales 5 15454.50 806.10
310 Graham 66 Sales 13 21000.00 200.30
320 Gonzales 66 Sales 4 16858.20 844.00
330 Burke 66 Clerk 1 10988.00 55.50
340 Edwards 84 Sales 7 17844.00 1285.00
350 Gafney 84 Clerk 5 13030.50 188.00