a8_cee3804_2011

a8_cee3804_2011 - CEE 3804: Computer Applications in Civil...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CEE 3804: Computer Applications in Civil Engineering Spring 2011 Assignment 8: Databases and Data Structures Date Due: May 3, 2011 (Class Time) Instructor: Trani Problem 1 An Excel file provided contains data for thousands of public airports in the U.S. A sample of the file is shown below. The file is called airports_2011.xls. This file contains information about thousands of airports compiled by the Dept. of Transportation and the FAA in 2011. Table 1. Sample File Airports_2011.xls. Task 1 Import the Excel file into Access and select the Airport ID as the Primary Key of the table. Task 2 According to 49 USCS § 40102 [Title 49. Transportation; Subtitle VII. Aviation Programs; Part A. Air Commerce and Safety; Subpart I. General], a large hub airport is defined as "a commercial service airport that has at least 1.0 percent of the total passenger boardings." Create an MS Access query to select and count the airports in the U.S that would be considered Large Hubs according to that definition. Show me the table of the Large Hub airports in a screen capture or a table.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

a8_cee3804_2011 - CEE 3804: Computer Applications in Civil...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online