Attribute data

Question 1

attribute table

Answer 1

contains information about features with 1 row for each feature linked to the spatial data by an FID

Question 2

records

Answer 2

rows in a table

Question 3

fields

Answer 3

columns in a table

Question 4

standalone table

Answer 4

exists independently of a geographic dataset

Question 5

flat file database

Answer 5

stores rows of information in a text or binary file, simple but inefficient management system

Question 6

hierarchical database

Answer 6

has multiple files each containing multiple records and fields, related tables connected by a fixed key

Question 7

relational database

Answer 7

multiple tables stored as files without predefined relationships, the user can temporarily join tables sharing a common field, preferred management system

Question 8

key

Answer 8

used to join tables via a shared field, this can be undone at any time

Question 9

join table

Answer 9

the source table, contains the information to be appended

Question 10

target table

Answer 10

the destination table, receives the appended information, can join multiple join tables to a single target

Question 11

cardinality

Answer 11

numeric relationships between objects in one table and their match in another, listed as target to join

Question 12

rule of joining

Answer 12

there must be only one record in the join table for each record in the target table, joins are possible for one to one and many to one

Question 13

relate

Answer 13

keeps tables separate but allows for analysis similar to a join, used for one to many cardinality

Question 14

case field

Answer 14

specified field used to create groups to analyze smaller chunks of data

Question 15

field definition

Answer 15

must be entered before any data can be entered into a field, cannot be changed

Question 16

field length

Answer 16

defines how many characters can be stored in a text field

Question 17

ASCII

Answer 17

standard by which byte codes are defined for storing letter, number, and symbol codes

Question 18

binary

Answer 18

more efficient for storing numbers

Question 19

float

Answer 19

floating point field stores 8 sig figs of information, used for very large or small numbers

Question 20

double

Answer 20

field that stores 16 sig figs of information, used for very large or small numbers

Question 21

domain

Answer 21

rule about the allowable content of a field, coded domains provide a list of values, range domains specify an min or max

Question 22

schema of a table

Answer 22

fields, data types, properties, domains, and other characteristics of a table

Question 23

fields view

Answer 23

used to view and modify the properties of a table

Question 24

calculate fields tool

Answer 24

used to calculate new fields based on existing fields, must make a new field first or it will destroy the existing data

Question 25

add geometry attributes tool

Answer 25

calculates feature measurements in a new field

Question 26

short text fields

Answer 26

+-32,000

Question 27

long text fields

Answer 27

+-2,147,000,000

Question 28

field summary

Answer 28

creates a new stand alone table with summary statistics for each feature