Database Management & Queries

1) A database management system is a specialized computer program for organizing and manipulating data.  It typically supports complex structures to provide security, stability, and mulitple users.

2) A one-to-one relationship is where one attribute in one table corresponds to the same attribute in another table.  A many-to-one relationship is where many attributes in one table correspond to one attribute in another table.

3) The benefits of relational databases include easy database querying and easy combination of data in separate tables.

4a) In the Landuse feature class, the LAND_USE field contains attributes, specifically a land use attribute for each feature/object on the map.

4b) In the LanduseInfo.dbf table, the LAND_USE field simply contains data (text) independent of the map.

5a) The appended fields are OBJECTID_1, LAND_USE, LU_DESCRIP, LU_GENERAL, LU_TYPE, SqMiles, Acres, Shape_Leng, and Shape_Area.

5e) There are 92,238 acres of open lands.

Map Design & Text

1) The information used from dynamic labels comes from the layer attribute table.

2) Create a layer of selected features and label the new layer.

3) It is impossible to adjust the position of dynamic labels.  To do so, dynamic labels must become annotations.

4) To adjust graphics, select the Select Elements Tool.

5) The two types of annotations are database annotations and map annotations.

-

1) It is possible to create ArcMap templates.

2) It is possible to save a template (.mxt) map as an .mxd file.

3) To access a map template, either start ArcMap with a template, or open a template while already in ArcMap.

4) Add and display the data, and then open the symbology tab of the layer properties to set the default display options.

5) It is possible to change the color of a graphic circle by changing the properties in the symbol selector, or by changing the properties under the symbology tab of the layer properties.

-

1) Always adjust the paper and page orientation and size before setting up a map layout.

2) The data view has a different scale from the layout view, because the data view displays only the active data frame, while the layout view displays all data frames on a page as if ready for printing.

3) The three customization options for scale bars are the division value, number of divisions, and number of subdivisions. 

4) It is important to use the 1:1 (Zoom to 100%) button because it displays the map in its actual size in layout view.

5) A graphic added to data view stays fixed in its original data frame, while a graphic added to layout view is on top of and independent of all the data frames, and does not display in data view.

-

1) A choropleth map is a type of map where shaded polygons display classified numerical data.

2) Layer (.lyr) files reference a data source that resides in another location, are easy to symbolize and label, and can exist outside of a map. 

3) A layer package (.lpk) file is a layer file along with a copy of its referenced data, as well as an XML file briefly describing the layer.  Layer packages make it easy to display and share the layer and its data when working in another map, without the extra step of importing the required shapefiles. 

4) The population of the City of Long Beach for the year 2000 is 461,522.

5) The population of the City of Los Angeles for the year 2000 is 3,694,820.

6) A document hyperlink is a link to a document.  A uniform resource locator (URL) hyperlink is a link to a web page.  A macro hyperlink is a link to a macro.

Symbolization and Classification

1) Large-scale maps might have more point and line symbols, while small-scale maps might have more polygon symbols.  Generally, as the scale increases, more detailed symbolization is possible. 

2) To change a layer symbol's colors, either left-click or right-click the layer symbol in the table of contents to open up a (different) color palette and select a color, or double-click the layer to open up the layer properties, and under the symbology tab, change the color ramp.

3) To open the graduated symbols classification option, double-click the layer to open the layer properties.  Next, open the symbology tab, and under the show menu, select quantities.  Then select graduated symbols.

4) Other symbology styles include Public Signs, Real Estate, Survey, Transportation, and Utilities.

5) It is possible to permanently save layer symbology for later use by creating a layer file of the symbology.

6) Pyramids improve the raster dataset drawing speed by displaying the raster dataset at coarse resolution when zoomed out and at fine resolution when zoomed in.

7) To change the layer name, simply select the layer, then click the layer name once, and type in the new name.

8) Normalization is dividing one attribute by another in the symbology tab of the layer properties.  For example, normalizing population by area will express population density in the range column.

9) The dots on dot density maps are random, so they might not show the actual geographic distribution of density.  For example, a population dot density map of Africa would show dots scattered throughout Egypt, when most of Egypt's population density is along the Nile River.