Exam 3: Databases and Data Warehouses

Assume you have an order entry database with an Order file and a Customer file. The Order Date field most likely would be the common field used to relate the two files.

A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A database management system helps you specify the _____ organization of data within a database.

The _____ uses a series of logically related two-dimensional tables or files to store information in the form of a database.

A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Operational databases are databases that support OLAP.

Microsoft Access is an example of a(n) _____.

Foreign keys uniquely identify records.

A(n) _____ subsystem controls facilities for backing up the database and establishing security.

Which part of a relational database contains the logical structure for the information?

Online analytical processing (OLAP) is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

What is the difference between multidimensional analysis and statistical analysis?

To determine the impact of an advertising blitz based on a specific product line for the northern region in the 4th quarter, a _____ would be used.

Which organizational function is responsible for developing security procedures for an organization?

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.

A(n) _____ uses artificial intelligence to build business intelligence.

A(n) _____ represents how users see information to meet their particular business needs.

A database management system contains five important software components. Which of the following components allows you to define the structure of a database?

What is the purpose of a data warehouse?

A data dictionary is a two-dimensional table used to store data within a relational database.