Quiz #6
The person responsible for updating and maintaining website content.
A content editor
A field (or group of fields) that uniquely identifies a given record in a table.
A primary key
Determines which things go together
Affinity grouping
What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome?
Analysis paralysis
Enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
Business critical integrity constraints
Assigns records to one of a predefined set of classes.
Classification
A heterogeneous population of more homogeneous subgroups.
Clustering segments
Who is the person responsible for updating and maintaining website content?
Content editor
logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
Data Warehouse
Is the smallest or basic unit of information.
Data element (or data field)
What is the ultimate outcome of a data warehouse?
Data marts
Logical data structures that detail the relationships among data elements by using graphics or pictures.
Data models
A problem associated with dirty data?
Duplicate data
Stands for extraction, transformation, and loading.
ETL
Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part. Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.
Granularities
Which of the following is a problem associated with dirty data?
Inaccurate data Misleading data Nonformatted data
Means immediate, up-to-date information.
Real-time information
What is another term for data that is already contained in a database or a spreadsheet?
Structured data
-Numbers and types of operational databases increased as businesses grew. -Many companies had information scattered across multiple systems with different formats. -Completing reporting requests from numerous operational systems took days or weeks
Why were data warehouses created?