Database Flashcards

1
Q

What is a database?

A

Organized data, typically in tables

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

DBMS

A

Data base management system (paper, digital)

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

What is a record?

A

All of the information about an entity (species, class, volume, height)

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

What is a field?

A

A category of information arranged in a column (ID number, Name, Phone number, $ owed).

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

What is the primary key?

A

A unique ID (student number)

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

What is a table?

A

A set of info for each “subject” (contact info, academic record, accounts.)

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

What are some advantages of a database?

A
  • Data stored independently of software
  • Simple structure
  • Redundancy minimized (consistent data)
  • Reduced data errors (error checks)
  • Easy to update (maintain data)
  • ready access to data (Variety of people, uses)
  • data security (restricted rights to view/edit) Students only can manipulate U drive in VIU database.
  • Basic analysis is simple
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are some basic analysis methods

A

Sorting,
Searching,
Querying

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

What are the generic field types?

A

Text / string (character based data) - No math
-may contain numbers not used in calculations (ID number)
Numbers
-Integers or Real numbers

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

Differentiate between precision and scale

A

Precision is the number of digits. It is independent of decimals, can include “-“ and includes “0 placeholder if a fraction.”
Scale is the # of decimal places

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
What is the scale and precision of the following numbers 
99
32000
0.0012
-123.15
A

99 - p2 s0
32000 p5 s0
0.0012 p5 s4
-123.15 p6 s2

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

Can you change the database once you create it in ArcGis?

A

No, so go big

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

What are the choices for integer in the number field?

A

short

long

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

What are the choices for the real number (decimal) field?

A

float

double

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

What field type for

A
  • Stand label (FC 841) - Text
  • Stand height (35.6) - Real number + float
  • Site index (24) - Integer - short
  • area - (12.3) - Real number - float
  • area - (123,000) -Integer - long
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are blobs?

A

Any file type attached

17
Q

What are the 2 choices for the numbers field type?

A
  • Integer

- Real number (decimal)

18
Q

How do you determine what field data falls under

A
  1. Can i do math with it? If no then it is text/string
  2. Does it have a decimal? if no, Integer
  3. Assume that the integer is “long” or the real number is “double”.
19
Q

How any parts to a query?

A

3
-field name - top of the table (ex. m3/ha)
-relational operator (=, less than, greater than.)
-value (ex. 400)
sumary ( m3/ha greater than 400 )

20
Q

What is a complex query?

A

more than 1 criteria

21
Q

How do you perform a complex query?

A

Using the word AND will specify that both criteria must be met
Using OR specifies that only one criteria must be met
Using NOT eliminates criteria

22
Q

What is a boolean operator?

A

words like AND, OR and NOT to refine search

23
Q

What things in GIS utilize database tables?

A

-attributes organized
-spatial data managed (can’t see it)
spatial data and attribute data are linked

24
Q

In table relation, differentiate between primary and secondary key.

A
  • Primary key is the ID column that is in the destination table (IN GIS IT IS ALWAYS THE MAP TABLE)
  • Secondary key is the outside source table being brought in.
25
What ar the different relations?
- One to one - Many to one - One to many
26
What does many to one mean?
Many records in the destination table relate to one record in the outside source table. tables are joined
27
Can you edit data in the outside source table?
No, because you are not in it.
28
What does one to many mean?
One record in the data table relates to many | -Relates / Links table (Not joined)
29
What is the different between join and a link?
A join can be performed with M:1 or 1:1 relations. | A link can be performed with a 1:M relation.