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.