Wednesday, October 27, 2010

Lab8 1. What are the primary functions of a database management system? The primary functions of a database management system is for organizing and manipulating data. 2. What is a one-to-one relationship between tables? A many-to-one? A one-to-one relationship between tables is the matches in the nonspatial table in which one table can have no more than one matching row in another table. A many-to-one relationship table is when a table has several matching rows with another table. 3. Why are relational databases so popular (i.e. what are the benefits)? Relational database have several benefits to them, so consist of having series of tables with contain data. In this tables there are rows and coulmns. Rows contain the records while the columns contain the fields. The attribute data stored in the tables can be queryed for flexibility. The coordinate data is stored in a network database. a. What is the Data Type of the LAND_USE field in the Landuse feature class? SHAPE FILE, SPATIAL DATA b. What is the Data Type of the LAND_USE field in the LanduseInfo.dbf table? TEXT, TABULAR DATA, ATTRIBUTE DATA a. Join the LanduseInfo.dbf file TO the Landuse feature class. Explore the table. What are the new fields that have been joined (appended)? The SHAPE Field, LU_DESCRIP, LANDUSE, LU_TYPE, SQMILES, ACRES, e. How many total acres of Open Lands (including Open Land Uses) exist in this new feature class? 280645

1 comment: