chapter 2 Flashcards
(28 cards)
what is data housed within a company
internal data sources
what is data housed outside the company
external data
what is the name of the companys internal integrated and centralized information system
enterprise system
what is the name for fields that appear as columns that contain descriptive chareacteristics about observations in a table
attributes
every table must have
primary key
T/F foreign keys uniquely identify each observation
false
the underlying, truthfulness, cleanliness, and trustworthiness of data
veracity
create relationships between two tables so that database users can look up details of the observations based on the primary/foreign key relationship
foreign keys
speed at which data is generated or rate at which data can be analyzed and accessed
velocity
name of term that describes data stored across multiple databases to greater storage of data and increased speed of analysis
distributed computing
a farenheit temp scale is an example of
interval data
data that cant be ranked is
nominal data
any attribute thats characterized as categorical
dimension
not a meaningful zero
interval
has a meaningful zero
ratio
excel functions that removes characters but doesnt impact white space
clean functions
categorical data that cant be ranked
nominal data
has a data limitation due to memory constraints
microsoft excel
steps in preparing data for analysis
ensure data, validate data, cleanse data, perform preliming exploratory analysis
characterized as numerical
measure
has natural order that allows them to be ranked
ordinal data
numbers that represent quantitites like transactions amount net income
numerical data
data that hasnt been processed
raw data
data structured into rows and columns
tabular data
