Chapter 11 (notes 1)

Hyperlink

A Web address is stored as a(n) ________ field in a database.

Range

A ________ check allows you to set credits allowed for students during one quarter from 0 to 21.

Consistency

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

Select query

A ________ displays a subset of data from a table (or tables) based on the criteria specified.

Database

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

Default value

A ________ is automatically displayed in a field unless the user enters something different.

One-to-one

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

Filter

A ________ temporarily displays records that match the specified criteria.

Warehouse

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place.

Data dictionary

A database schema is also called a(n) ________.

Completeness

A(N) ________ check determines whether all required fields were filled in.

Office support system

A(n) ________ is designed to improve communications and assist employees in accomplishing their daily tasks.

Query

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

External data

An example of ________ is customer demographic data purchased from third parties or statistics compiled by the federal government.

Knowledge base system

An expert system and a natural language processing system are both _.

Data mining

Classification, affinity grouping, and estimation are ________ methods used by managers to make their data more meaningful.

Integrity

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

Cube

Data in a multidimensional database is organized in a ________ format.

Mining of data

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

Primary key

Each record must have a unique field called a(n) ________ field.

Redundancy

If a business keeps two lists, one for employee payroll and one for employee benefits information, both containing name and address information, this is an example of data ________.

99999

If a numeric field has a size of 5, which is the highest number it can hold?

Internal data

In a data warehouse, data gathered from sales, billing, and inventory departments are examples of ________ sources.

Numeric

In a database, ________ fields store numbers used to perform calculations.

Record

In a database, a ________ is a group of related fields.

Field

In a database, a ________ is synonymous with a category of information.

Object

In a database, a chart is stored in a(n) ________ field.

Table

In a database, a group of related records is called a(n) ________.

A link between tables that defines how the data are related

In a relational database, what is a relationship?

Real time

In a transaction-processing system (TPS), if the TPS database is queried and updated while the transaction is taking place, this is called ________ processing.

Batch

In a transaction-processing system, if transaction data are accumulated until a certain point and then many transactions are processed all at once, this is called ________ processing.

exception reports

Management information systems (MIS) provide reports called ________, which show conditions that are unusual or need attention from users of the system.

Access

Microsoft ________ is a database management system.

Unstructured

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.

Dictionary

Prior to entering data into a database, you must create a data ________ entry for each field in the database.

relational algebra

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

natural language processing (NLP) system

The Siri speech-recognition feature on Apple's iPhone 4s is an example of a ________.

binary large objects (BLOBs

Unstructured data such as video clips and pictures are known as ________ because of the way they are encoded.

Data management system

What does the acronym DBMS stand for?

Join

When you want to extract data from two or more tables, you use a(n) ________ query.

Data mine

Which of the following is NOT a data source for a data warehouse?

Street address

Which of the following is NOT a likely primary key?

Implementing data mining

Which of the following is NOT a main operation of a database management system (DBMS)?

Redundancy

Which of the following is NOT a type of management information system (MIS) report?

Database information cannot be changed once it is entered.

Which of the following is NOT a typical disadvantage associated with databases?

They store data in table format

Which of the following statements about object-oriented databases is FALSE?

Relational

____ databases have the largest market share among the primary types of electronic databases.

Exporting

________ involves putting data into an electronic file in a format that another application can understand.

Artificial intelligence

________ is the branch of computer science that deals with the attempt to create computers that think like humans.

Normalization

________ is the process of reducing data redundancy by recording data only once.

Referential integrity

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

Field

________ size defines the maximum number of characters or digits that a particular field can hold.

Data centralization

helps to ensure data integrity by maintaining information in only one place.

Administrator

individual trained in the design and building of databases is called a database ________.