Lab #8: Database Management & Queries

I. Read Bolstad Chapter 8 and answer the following questions. 


1. What are the primary functions of a database management system? 
Prevent redundancy, increase data quality and independence, create centralized control and allow multiple users.


2. What is a one-to-one relationship between tables? A many-to-one? 
One-to-one is when one row in one table is linked to only one row from another table and one-to-many is when one row in one table is linked to many rows in another table.


3. Why are relational databases so popular (i.e. what are the benefits)?
They allow ad hoc requests/queries of the database, links are not preset, data is stored in separate tables and combined when needed for a query or report.


II. AFTER completing Ormsby Chapters 8 & 9, complete the following exercise.

4. 
a. What is the Data Type of the LAND_USE field in the Landuse feature class?
Text/String

b. What is the Data Type of the LAND_USE field in the LanduseInfo.dbf table?

Text/String

5.

a. Join the LanduseInfo.dbf file TO the Landuse feature class. Explore the table. What are the new fields that have been joined (appended)?

objectid1, Land_use, LU_DESCRIP, LU_GENERAL, LU_TYPE, SqMiles, Acres, Shape_Leng, Shape_Area.

e. How many total acres of Open Lands (including Open Land Uses) exist in this new feature class? 92236.77acres

Due: Wednesday, October 27th, 2010