a8_cee3804_2011_sol

a8_cee3804_2011_sol - CEE 3804: Computer Applications in...

Info iconThis preview shows pages 1–3. 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 Solution 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 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. The total number of passengers enplaned in the system are: 664,238,445. A large hub airport has 6.64 million passengers or more. Thirty one airports meet the large hub criteria. CEE 3804 Trani Page 1 of 9
Background image of page 1

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

View Full DocumentRight Arrow Icon
Table 1a. Large Hub Airports (in decreasing order). Task 3
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/01/2012 for the course CEE 3804 taught by Professor Aatrani during the Spring '07 term at Virginia Tech.

Page1 / 9

a8_cee3804_2011_sol - CEE 3804: Computer Applications in...

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

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