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 ________.