CSE 344 Midterm: CSE 344 UW 14 Winter Midterm Solution
Document Summary
The first several questions deal with a database that stores information about airlines, flights, and pilots. The database consists of the following tables: Flight(airline_code, number, from_city, to_city, depart_time, arrive_time, day, month, year) The underlined attributes are keys for each relation. The tables contain the following information: airline stores airline names and the two- letter unique code assigned to each airline. For this exam, we assume that airline_code is not null, i. e. , every pilot currently works for some airline. Flight gives information about each unique flight in the database. A flight has an airline_code ( aa", ua", etc. ), departure and arrival times as integers giving 24- hour clock time (e. g. , 1015 means 10:15 am, 1830 means. 18:30 or 6:30 pm), and integers giving the day, month, and year of the flight (e. g. , 7, 2, 2014 for. A single flight like aa" 125 may have many occurrences with different dates.
