Exam 6: Foundations of Business Intelligence: Databases and Information Management

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Databases record information about general categories of information referred to as ________.

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

Every record in a file should contain at least one key field.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

A DBMS makes the

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

OLAP is a tool for enabling

High-speed ________ use both relational and non-relational tools to analyze large datasets.

In a relational database, a record is referred to in technical terms as a(n)

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

Oracle Database Lite is a(n)

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

In terms of data relationships, associations refers to

The join operation

Data mining is a tool for allowing users to

A data warehouse may be updated by a legacy system.

A DBMS reduces data redundancy and inconsistency by

A(n) ________ view shows data as it is actually organized and structured on the data storage media.