Chapter Review Questions

$1.$ Describe the difference between an attribute table and a standalone table.

$2.$ Find a table of ASCII codes on the Internet and decipher this message written in decimal

numbers: $541041013283116463266101114110611141003211511397116116101100$

$3211111032971101003283786910190696833$

$3.$ Choose the best field type for each of the following types of data in a geodatabase and

explain your choice:

student GPA zip codes

state populations number of students in a class

state names birthdays

$4.$ What is the primary purpose of domains? Explain the difference between a coded domain and

a range domain.

pri$87339\_$ch$07\_211-244.$indd $226$

Attribute Data

$227$

$5.$ What is the cardinality of each of the following relationships? Assume that the destination is

on the left.

cities to counties parcels to zoning codes

capitals to states watersheds to wells

$6.$ You have a table of cities and a table of counties, both with a state abbreviation field. Can you

join them if cities is the target table? If counties is the target table? Explain your answer.

$7.$ Describe the difference between a join and a relate. When is a relate the only option?

$8.$ What is the function of a case field? Make up an example table with seven records, and use it

to illustrate your explanation.

$9.$ For each of the following changes made in the Fields view, state whether it will modify

the table view only, will modify the schema, or may do one or the other depending on the

Source setting:

deleting a field turning field visibility off

changing a field name making the field read$-$only

changing a field alias

$10.$ List at least four ways that a spreadsheet may not be suitable for importing into Pro.

Extend your knowledge

Read these sections of the Help for more information about tables

Help$>$ Data $>$ Data types $>$ Tables

Help$>$ Data$>$ Geodatabases $>$ The geodatabase $>$ Table basics

Help$>$ Data$>$ Geodatabases $>$ The geodatabase $>$ Data design