CSE 344 Midterm: CSE 344 UW 14 Winter Midterm
23 views8 pages
Document Summary
The exam is open textbook but otherwise you may not use any other references. No computers, electronics devices, phones of the smart or not- so- smart variety, telegraphs, telepathy, mirrors, smoke signals, or other contraptions permitted. The exam lasts 50 min. Please budget your time so you get to all questions. Please wait to turn the page until everyone has their exam and you are told to begin. You are here to learn. 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.