Exam 11: Behind the Scenes: Databases and Information Systems

Data staging consists of all of the following steps, EXCEPT ________.

A data dictionary is also referred to as a(n) ________.

Normalization means that there are no data entry errors in a database.

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

A(n) ________ check determines whether a required field such as LastName was filled in.

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

A group of related records is called a table.

________ data are information about how users of a company's website move through the web pages.

In a database, another term for a table is a(n) ________.

Data redundancy ensures that the data contained in the database is accurate and reliable.

A filter is limited to extracting data from a single table.

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

When creating a data warehouse, ________ is is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.