15) Geodatabase Development

Question 1

A collection of geographic datasets (tables, feature classes, and raster datasets) of various types held in a common file system folder, a Microsoft Access database, or a multiuser relational Database Management System.

Answer 1

Geodatabase

Question 2

________ is a database that is optimized to store and query data that represents objects defined in a geometric space.

Answer 2

Geodatabase

Question 3

Geographic Data Issue

Answer 3

1. Spatial Integrity Errors
2. Attribute Integrity Errors
3. Organization/Efficiency

Question 4

Geodatabase Solutions

Answer 4

1. Topology
2. Default Attribute Values
3. Attribute Domains
4. Subtypes
5. Attachments
6. Relationship classes

Question 5

Geodatabase Functionalities

Answer 5

Subtypes
Attribute Domains
Topology
Relationship Classes
Attachments

Question 6

________ allows you to categorize features within a feature class.

Answer 6

Subtypes

Question 7

________ are rules that describe the legal values of a field type, providing a method for enforcing data integrity.

Answer 7

Attribute Domains

Question 8

Two Types of Attribute Domains

Answer 8

Range Domains
Coded Domains

Question 9

________ specifies a valid range of values for a numeric attribute.

Answer 9

Range Domains

Question 10

________ specify a valid set of values for an attribute (e.g., ground surface type: pavement, gravel, sand).

Answer 10

Coded Domains

Question 11

________ enforces spatial integrity by defining how point, line, polygon features share geometry.

Answer 11

Topology

Question 12

________ manages the associations between objects in one class (feature class or table) and objects in another.

Answer 12

Relationship Classes

Question 13

Related objects can exist independently of each other.

Answer 13

Simple Relationship

Question 14

Destination objects can’t exist independently of origin
objects.

Answer 14

Composite Relationship

Question 15

In creating a relationship class, one is set to be the origin and another to be the destination.

Answer 15

Origin and Destination Classes

Question 16

It is the key field in the origin class of a relationship and often abbreviated as PK.

Answer 16

Primary Key

Question 17

It is the key field in the destination class of a relationship and often abbreviated as FK.

Answer 17

Foreign Key

Question 18

This specifies the number of objects in the origin class that can relate to a number of objects in the destination class.

Answer 18

Cardinality

Question 19

Types of Cardinality

Answer 19

1. One-to-One
2. One-to-Many
3. Many-to-Many

Question 20

One origin object can relate to only one destination object.

Answer 20

One-to-One

Question 21

One origin object can relate to multiple destination objects.

Answer 21

One-to-Many

Question 22

One origin object can relate to multiple destination objects and, conversely, one destination object can relate to multiple origin objects.

Answer 22

Many-to-Many

Question 23

________ provides a powerful way to associate non-geographic data with geographic information.

Answer 23

Attachments

Question 24

ESRI Steps in Geodatabase Design

Answer 24

1. Conceptual Design Phase
2. Logical Design Phase
3. Physical Design Phase