Question

Airline Flight Number Gate Destination Departure Time FlyRight 122 34 Detroit 08:10 JetGreen 221 22 Denver 08:17 JetGreen 122 33 Anchorage 08:22 JetGreen 323 34 Honolulu 08:30 FlyRight 199 13 Detroit 08:47 JetGreen 222 22 Denver 09:10 FlyRight 322 34 Detroit 09:44 (a) Give a key(s) for this database. (b) What operations should be performed if you want to know which airlines use gate 33? (c) What operations should be performed if you want to know whether there are any flights to Anchorage departing before 08:22? A flight is identified by the airline and flight number.

          Airline Flight Number Gate Destination Departure Time
FlyRight 122 34 Detroit 08:10
JetGreen 221 22 Denver 08:17
JetGreen 122 33 Anchorage 08:22
JetGreen 323 34 Honolulu 08:30
FlyRight 199 13 Detroit 08:47
JetGreen 222 22 Denver 09:10
FlyRight 322 34 Detroit 09:44

(a) Give a key(s) for this database.
(b) What operations should be performed if you want to know which airlines use gate 33?
(c) What operations should be performed if you want to know whether there are any flights to Anchorage departing before 08:22? A flight is identified by the airline and flight number.

Airline Flight Number Gate Destination Departure Time
FlyRight 122 34 Detroit 08:10
JetGreen 221 22 Denver 08:17
JetGreen 122 33 Anchorage 08:22
JetGreen 323 34 Honolulu 08:30
FlyRight 199 13 Detroit 08:47
JetGreen 222 22 Denver 09:10
FlyRight 322 34 Detroit 09:44

(a) Give a key(s) for this database.
(b) What operations should be performed if you want to know which airlines use gate 33?
(c) What operations should be performed if you want to know whether there are any flights to Anchorage departing before 08:22? A flight is identified by the airline and flight number.

Added by Francisca P.

Question

Please give Ace some feedback