Δεδομένα
for the FLIGHTS table
|
flno
|
ffrom
|
Fto
|
distance
|
departs
|
arrives
|
|
246
|
Denver
|
Chicago
|
1020
|
09:30
|
12:43
|
|
272
|
Chicago
|
Albany
|
820
|
13:20
|
16:13
|
|
292
|
Indianapolis
|
Chicago
|
190
|
10:44
|
11:40
|
|
895
|
Chicago
|
Los Angeles
|
2060
|
07:00
|
09:05
|
|
001
|
Los Angeles
|
Hong Kong
|
7240
|
14:00
|
19:20
|
|
607
|
Hong Kong
|
Singapore
|
1650
|
20:45
|
22:25
|
|
852
|
Beijing
|
San Francisco
|
6250
|
10:30
|
09:25
|
|
130
|
Los Angeles
|
New York
|
2790
|
07:00
|
15:09
|
for the AIRCRAFT table
|
aid
|
aname
|
Cruisingrange
|
|
1
|
Airbus A319
|
3000
|
|
2
|
Airbus A330
|
6400
|
|
3
|
Airbus A340
|
8000
|
|
4
|
Boeing 717
|
1580
|
|
5
|
Boeing 737-700
|
3800
|
|
6
|
Boeing 767-300
|
7080
|
|
7
|
Boeing 747-400
|
8380
|
|
8
|
Dornier 228
|
834
|
|
9
|
Ilyushin Il62
|
11000
|
for the EMPLOYEES table
|
eid
|
ename
|
salary
|
|
1
|
Jose Abbott
|
58000
|
|
2
|
Sharon Caddas
|
103000
|
|
3
|
John Erwin
|
55000
|
|
4
|
Alva Hinton
|
67000
|
|
5
|
Tony Jekins
|
81000
|
|
6
|
Venus Jordan
|
45000
|
|
7
|
Jeffrey Leming
|
118000
|
|
8
|
Thomas Moore
|
79000
|
|
9
|
Yolanda Napolitano
|
69000
|
|
10
|
Mihai Rosenberg
|
48000
|
|
11
|
Judith Sorenson
|
42000
|
|
12
|
Clande Woods
|
58000
|
for the CERTIFIED table
|
eid
|
aid
|
|
1
|
1
|
|
1
|
4
|
|
2
|
2
|
|
2
|
6
|
|
2
|
7
|
|
3
|
1
|
|
3
|
5
|
|
4
|
1
|
|
4
|
4
|
|
4
|
5
|
|
5
|
3
|
|
5
|
7
|
|
7
|
3
|
|
7
|
6
|
|
7
|
7
|
|
7
|
9
|
|
9
|
2
|
|
9
|
5
|
|
9
|
6
|
|
10
|
4
|
|
10
|
8
|