Exam 4: Ethics and Information Security

A data warehouse aggregates transactional data into analytical information throughout an organization into a single repository.

________ reveals the degree to which variables are related and the nature and frequency of these relationships in the information.

Which of the following represents market basket analysis?

What are characteristics or properties of an entity class called?

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

What are forecasts?

A key idea within data warehousing is to take data from multiple platforms/technologies and place them in a common location that uses a common querying tool.

Compare relational integrity constraints and business-critical integrity constraints.

In the relational database model, what is a collection of similar entities?

Market __________ analysis analyzes such items as websites and checkout scanner information to detect customers' buying behaviour and predicts future behaviour by identifying affinities among customers' choices of products and services.

Which one of the following provides a company the best competitive advantage in the global market place?

What is an integration?

Data mining can begin at a summary information level and progress through increasing levels of detail.

Forecasting is a common form of __________.

What directly accesses a database?

A key idea within data warehousing is to take data from ________ and place them in a common location that uses a common querying tool.

The data warehouse is a location for all of a business's information.

Information in a data warehouse contains layers of columns and rows and this is known as __________ databases.

To increase the quality of organizational information and thus the effectiveness of decision making, businesses must formulate a strategy to keep information ____.

When does information cleansing occur in the data warehouse?