Exam 11: Behind the Scenes: Databases and Information Systems

________ databases are better at handling unstructured data such as audio clips, video clips, and pictures.

A(n)________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information.

Data that describe other data are called________.

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

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

To temporarily display records from a single table that match certain criteria, you would use a(n)________.

Real-time processing means that transactions are updated when they occur.

A business that updates its records all at once at the end of the business day uses ________ processing.

In a Microsoft Access database, an active web page, email address or existing file is stored as a(n)________ field.

A group of related records is called a table.

A(n)________ is a way of retrieving information from one or more tables that defines a particular subset of data.

A ________ is a group of related data that can be stored, sorted, organized, and queried.

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

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.