Assignment #$3-$ Attribute Tables $(50$ pts$)$

Part $1-$ Lecture & Bolstad Review

Use these three data tables to answer the following questions:

Veg.shp

$\backslash$table$[[$OID$,$SHAPE,Area,VEG,Grazing Intensity$],[0,$POLYGON,A$,$Oats,High$],[1,$POLYGON,B$,$Yellow Star Thistle,None$],[2,$POLYGON,C$,$Poison Oak,Medium$],[3,$POLYGON,D$,$Yellow Star Thistle,None$]]$

VegStructure.dbf

$\backslash$table$[[$Number$,$VEG,Type$],[0,$Oats,Grass$],[1,$Yellow Star Thistle,Broadleaf$],[2,$Poison Oak,Shrub$],[3,$Medusahead,Grass$],[4,$Erodium,Grass$]]$

Erosion.dbf

$\backslash$table$[[$Number$,$Grazing Intensity,Erosion$],[0,$High,High$],[1,$Medium,Medium$],[2,$Low,Low$],[3,$None,Low$]]$

a$.$ List which tables are from shapefiles and which are from look$-$up tables? $(3$ pts$)$

Shapefile Tables

Look$-$Up Tables

Text

b$.$ List the column heading of the keys in each table. There could be more than one for each table. A key is a column$/$field where each instance is unique. $(6$ pts$)$

Veg.shp

VegStructure.dbf

Erosion.dbd

c$.$ If you wanted to map the areas of high erosion, which of the two tables would you link? $(4$ pt $)$

d$.$ If you wanted to map the areas of high erosion, what would be the common column$/$fields you would use $($they can have different names$)?(4$ pts$)$

e$.$ If you wanted to map the areas of high erosion, what type of linkage would you use: Join or Relate? $(1$ pt$)$

f$.$ If you wanted to map the areas of high erosion, describe the linkage cardinality? $(2$ pts$)$