Friday, October 5, 2007 we had a lecture on Chapter 8 and done Excercises Chapter 8 & 9 in the Arc GIS Book.
Chapter 8 is about Queries.
Queries are select by attribute or location.
Text always has single quotes around it. Example, 'TEXT'
Tables contain attribute data. Shapefiles, coverage, and geodatabase
You have Attribute tables and Standalone tables.
Attribute Tables has the shapfield for a dead giveaway.
Sources, fields, Field types, Field Characteristics, editing fields are part of working with queries.
Table cardinality is how may objects are related to each other.
one to one. One to many
many to one. Many to many
Join = one to one, Relate = one to many.
Example of Chapter 8 is the first picture.
Example of Chapter 9 is the 2nd picture.