Chapter 8 - Attribute Data and Tables Flashcards

1
Q

These are non-spatial properties of surface features

A

Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Attributes are stored in these

A

Attribute tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Both of these types of data can have attributes

A

Vector and raster

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are two types of linkages of spatial and attribute components?

A

One-to-one or many-to-one

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

GIS attribute tables are typically stored in this

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Databases provide means for these two data functions

A

Data storage/management and data retrieval/analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are four types of database models?

A
  1. Flat file; 2. Network; 3. Hierarchical; 4. Relational
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

This is the most common type of database used today

A

Relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

In what year were relational databases introduced?

A

1968

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are three advantages of relational databases?

A
  1. More flexible; 2. Easy to create/maintain; 3. Easy to understand
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is a disadvantage of relational databases?

A

Slower processing (less of a problem now that computers are faster)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Databases are made of these tables

A

Cross-linked data tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

This is another term for tables

A

Relations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are two terms for table rows?

A

Records or tuples

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A record is a set of these for an entity

A

Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are two terms for columns?

A

Attributes or items

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

These are descriptive variables for surface features

A

Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

These are one or more columns used to index records

A

Keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

These link multiple tables together

A

Keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

This is a form of computer science logic

A

Relational algebra

21
Q

Relational algebra is the basis for manipulating this

A

RDB data

22
Q

How many operators does relational algebra use?

A

8

23
Q

Relational algebra operators use one or more of these to create a new one

A

Tables

24
Q

What are at least five of the eight relational algebra operators?

A
  1. Restrict; 2. Project; 3. Product; 4. Divide; 5. Union; 6. Intersect; 7. Difference; 8. Join (relate)
25
Q

This relational algebra operator provides a subset of a table by rows

A

Restrict

26
Q

This relational algebra operator provides a subset of a table by columns

A

Project

27
Q

This relational algebra operator provides a table with all possible combinations

A

Product

28
Q

This relational algebra operator provides the inverse of a product

A

Divide

29
Q

This relational algebra operator combines tables top to bottom

A

Union

30
Q

This relational algebra operator finds overlap in rows between tables

A

Intersect

31
Q

This relational algebra operator finds non-overlap in rows between tables

A

Difference

32
Q

This relational algebra operator combines tables using a key column

A

Join (relate)

33
Q

These select records based on some criteria

A

Database queries

34
Q

What are two types of database queries?

A

Simple query and compound query

35
Q

In this type of database query, selection is based on a single criteria

A

Simple query

36
Q

What symbols are used in simple queries?

A

=, <>, >, <

37
Q

In this type of database query, selection is based on multiple criteria

A

Compound query

38
Q

Compound queries use chain criteria with these three words

A

And, or, not

39
Q

Compound queries use these operators

A

Boolean operators

40
Q

These index table records and link different tables

A

Database keys

41
Q

This is an attribute or combination of attributes that uniquely identifies a record

A

Superkey

42
Q

There are none of these in superkeys

A

Null values

43
Q

Is a set of attributes containing a superkey also considered a superkey?

A

Yes

44
Q

Can a table have multiple superkeys?

A

Yes

45
Q

This is a minimal superkey that has the fewest number of attributes that ID a record

A

Candidate key

46
Q

This is a single candidate key chosen to identify and access records

A

Primary key

47
Q

May primary key attributes have null values?

A

No

48
Q

These are attribute fields in a table that match a primary key of another table

A

Foreign key

49
Q

Foreign keys are used to do this

A

Cross-reference tables