64 notecards = 16 pages (4 cards per page)
_______ is an interactive website kept constantly updated and
relevant to the needs of its customers using a database.
The process of analyzing data to extract information not offered by
the raw data alone.
_______ provides details about data
_______ stores information about a person, place, thing, transaction,
_______ helps users graphically design the answer to a question
against a database.
An example of transactional information would be:
The smallest or basic unit of information is referred to as:
Fixing or discarding inconsistent or incorrect data is known as:
Revealing the relationship between variables with nature and
frequency of relationship is known as:
T/F A representation of multidimensional information can be referred to as a "cube".
Answer: (1) The content is easy to manage. (2) It is easy to store large amounts of data. (3) It is easy to eliminate human errors.
T/F Data mining is one of the four aspects of Data we need to consider?
T/F All Data systems have the same format?
Can Databases be linked together and if so what is it called?
They can be linked together, even multiple databases at a time and this is called a relational database.
T/F Metadata is data about data?
Companies use ______________ techniques to analyze particular data in
order to compile a complete picture of their operations allowing
identification of trends and improved forecasts.
The primary purpose of a data warehouse is to combine information.
If a grocery store is trying to analyze data regarding what
percentage of the time customers buying bread are also buying peanut
butter they would use the data mining technique known as:
It is crucial for businesses to understand digest, analyze and filter
high-quality information in order to see growth and success in their
industry. Information that has a primary purpose to support daily
operational tasks is known as _______________.
There are common characteristics of high-quality information to make
certain that systems do not suffer from data integrity issues. Which
of these characteristics is not one of them?
True/False. Information cleansing or scrubbing is a process that weeds out and fixes or discards incorrect or incomplete information.
True/False. Web mining analyzes unstructured data to find trends and patterns in words and sentences.
What is a technique used to divide information sets into manually
exclusive groups so that members of each group are close together and
different groups are far away?
The data warehouse enables business users typically managers, to be
more effective in all these ways EXCEPT:
Data governance refers to the overall management of the availability usability, integrity, and security of company data.
A data dictionary:
A physical view of information focuses on how individual users
logically access information to meet their own particular business
Another word for information cleansing is:
The three common forms for mining structured and unstructured data
Explain the difference between transactional and analytical information.
Transactional information encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. Analytical information encompasses all organizational information, and its purpose is to support the performing of managerial analysis tasks. Analytical information is useful when making important decisions such as whether a company should build a new plant of hire more sales personnel.
What is a major pitfall of real-time information?
Which of the following is NOT a serious consequence that businesses
face when using low-quality information?
Name two defined policies that a company that supports a data governance program specifies.
2 of these:
Columns and fields such as the primary key and foreign key are
examples of what?
T/F The four aspects of data are data type data timelines, data quality, and data governance
A _____ key is one or more columns that can be used to identify a unique row in a table?
_____ keys are keys from a different table than the one in which they reside?
T/F Market basket analysis is the items people tend to buy separate
T/F A statistical analysis requires high quality data a sturdy DBMS, and a solid statistical skills
The four primary traits that help determine the value of information
Of the five common characteristics of high quality information which
of the following has to do with each transaction and event only being
represented once in the information?
Which of the following is not true?
List some examples of serious business consequences that can occur due to using low quality information to make decisions.
-Inability to accurately track customers.
Which of the common forms for mining structures and unstructured data
is a technique used to divide information sets into mutually exclusive
groups where members of each group are closely grouped together while
the different groups are as far apart as possible?
What are the four aspects of data?
Type, timeliness, quality, and governance
What are the two types of data?
Transactional and analytical
Which of the following is NOT a characteristic of Data quality?
A field that or group of fields that uniquely identifies a given
record in a table is __________.
Which of the following is the most inclusive?
What are five common characteristics of high-quality information? Name two or three
Accurate, complete, consistent, timely, unique
What is a primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the
What are some data-driven website advantages?
- Easy to manage content
What is the primary purpose of a data warehouse?
Association detection reveals the relationship between variables along with the nature and frequency of the relationships.
Data governance refers to the overall management of the availablility usability, integrity, and security of company data.
________ is a process that weeds out and fixes or discards
inconsistent incorrect, or incomplete information.
What is data mining?
The process of analyzing data to extract information not offered by the raw data alone.
_______ are predictions based on time-series information.
Cluster analysis is a technique used to divide information sets into
mutually exclusive groups such that the members of each group are as
close together as possible to one another and the different groups are
as far apart as possible.