Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
45 Cards in this Set
- Front
- Back
- 3rd side (hint)
What is a database?
What does it include? |
A collection of related information
|
Tables, Observations, Fields
|
|
Synonym-Fields
|
Varibles, Columns
|
|
|
Synonym- Observations
What is a observation? |
Records
|
A row of information about the feature. Usually of one specific marker for ex. a row of information of the marker: (Country name).
|
|
What are obervational units?
In geographical databases, what do observational units represent? |
Things we are taking measurements for.
|
Some sort of geographical feature or location
|
|
Name the 10 data types?
|
Text, Date, Memo, Boolean, Integer, Long Integer, Single (Number), Double (Number), Currency, BLOB (OLE Object)
|
|
|
Text
|
Alphanumeric information being numbers or letters ranging from 1-255 characters
|
|
|
Memo (and example of one)
|
Storybook narratives of information.
Ex. If you wanted to add a countries history to the database |
|
|
Date
|
How many days have passed in between two dates.
|
|
|
Boolean
|
True or False values
|
|
|
Integer
|
Whole numbers that are positive and negative.
No fractions |
2 bytes of space
+-32,000 |
|
Long Integer
|
4 bytes of space
|
+- 2.1 Billion
|
|
Single (number)
|
Fractional, decimal values that have 6-7 significant digits.
ex. 245.678 |
4 bytes of space that include rounding errors
|
|
Double (number)
|
Fractional, decimal values that have 15-16 significant digits
|
8 bytes of space that include rounding errors
|
|
Currency
|
Financial calculations w/o losing a cent.
|
Can be used for managing money data
|
|
BLOB
|
Binary Large Object
|
Image files, photographs, PDF, word documents
|
|
What can you do with data queries?
|
Queries are the means by which database management software retrieves information from a database. Queries can also be used to update information in a database.
|
|
|
What are the two types of operators used with queries?
|
Boolean operaters and Relational operaters
|
|
|
What is a relational operater?
|
>, <, =, >=, <=, <>
|
|
|
What is a boolean operator?
|
AND or NOT functions putting together complex data
|
|
|
What is SQL? and what does it stand for?
|
SQL is the special language for construction queries.
|
It stands for Structured Query Language.
|
|
What are some data query types?
|
Update, Select, Totals, Make Tables
|
|
|
Explain the update query?
|
You can create new field information from one or more existing fields.
Ex. Computing population density information into a table |
|
|
Explain the select query function?
|
Can utilize both of the operators comparing 2 or more fields include and specific data.
Ex. Select Clause: fields- Country and Population from table 1 Where Clause: Population > 10000 AND religion is 'Muslim' |
|
|
Totals query?
|
generate summary information about selected records in your database.
Ex. Select sigma button to get the total population, average population, and land area for your County database |
|
|
Make Tables query?
|
Transfers query data into the table.
|
|
|
How do you calculate percent change over time?
|
%change= (Later measurement-Earlier measurement) / Earlier measurement x100
|
Ex. NC's pop1990= 6,628,637.
NC's pop2000= 8,049,313. (8,049,313-6,628,637) / 6,628,637 *100= 21.43% |
|
What is Primary data?
|
First-hand data collection. Data you physically collected.
|
|
|
Ex. of Primary data in physical geography?
|
Rainfall, soil data, wind
|
|
|
Ex. of Primary data in human geography?
|
Population, surveys
|
|
|
Secondary data?
|
Data others collected
|
|
|
Ex. of secondary data in physical geography?
|
US Dept. of Agriculture
|
|
|
Ex. of Secondary data in human geography?
|
US Census
|
|
|
What is Metadata?
|
Process of how data was collected
|
|
|
What is continous data?
Ex.? |
Continous data does not change over abrutely space
|
Air tempurature has no change over state lines
|
|
What is discontinuous data?
Ex.? |
Data that can change abrutely over space.
|
Laws. Categorical information.
|
|
What does a grouped frequency table show?
|
The interval, tally, and count of the data table
|
|
|
How do you construct an interval?
|
Choose a number between 10 and 20 in order to find the initial interval width.
|
|
|
How do you din the initial interval width?
|
Calculate the range (Max number - Min number) and divide it by the interval (# between 10-20), round your answer to a convient number. ex. 2,882,333 to 3,000,000
|
|
|
How do you get a starting point for the frequency table?
|
Round you lowest number down to a reasonable point.
ex. 536,180 down to 500,000 |
|
|
What goes in the count and tally piece of the frequency table?
|
Tally- # of markers that fall into the interval
Count- total # of tallies for each interval. |
|
|
What is the purpose of a histogram?
How do we create one? |
The histrogram shows us the shape of our data
|
By imputing the data from the frequency table
|
|
What three things do frequency tables and histograms tell us?
|
The range (high and low score), Distributional shape (usually follows the standard normal distribution, bell curve), outliers (ex. California in U.S. population)
|
|
|
Pie Charts
Ex.? |
Show parts of a whole.
|
Proportions or percentages of the total.
|
|
Bar Charts
Ex.? |
Discrete catagories or individual features
|
Comparing size, magnitude, or length of several observations or features
|
|
Line Chart
Ex.? |
Continous data changes over time and across space
|
Change over time, Change with distance
|