Chapter 11 TIA
________ is the branch of computer science that attempts to create computers that think like humans.
Artificial intelligence
________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.
Exporting
A last name field is an example of a field that should have a default value.
F
A summary report generated by a MIS provides a list of the transactions that occurred during a specified time period.
F
Data redundancy ensures that the data contained in the database is accurate and reliable.
F
Employees' last names would usually make an appropriate primary key field.
F
In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.
F
Normalization means that there are no data entry errors in a database.
F
Small slices of a data mart are called data warehouses.
F
The information in a data mart spans an entire enterprise.
F
When using Access, the text of the Declaration of Independence would be stored in a short text field.
F
________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.
Referential integrity
A database schema defines the name, data type, and length of each field in the database.
T
A filter is limited to extracting data from a single table.
T
A group of related records is called a table.
T
Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.
T
In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.
T
Data ________ helps to ensure data integrity by maintaining information in only one place.
centralization
A(n) ________ check determines whether a required field such as LastName was filled in.
completeness
A ________ check compares the values of data in two or more fields to see whether those values are reasonable.
consistency
You can set a ________, which is automatically displayed in a field unless the user enters something different.
default value
Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system.
exception
In a database, the term ________ is synonymous with a category of information.
field
You would use a ________ in a database to temporarily display records of residents for the city of Boston.
filter
Data ________ means that the data contained in a database is accurate and reliable.
integrity
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
long text
Data staging consists of all of the following steps, EXCEPT ________.
mining the data
Siri, the personal assistant application on Apple's iPhone is an example of a ________.
natural language processing (NLP) system
________ is used to ensure that data is organized most efficiently in a database.
normalization
A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
one-to-one
A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.
query
A ________ displays a subset of data from a table (or tables) based on the specified criteria.
select query
Which of the following is a likely primary key in a student information record?
student id number
In a database, a group of related records is referred to as a(n) ________.
table
Most databases can import electronic data from other software applications.
T
Real-time processing means that transactions are updated when they occur.
T
Data in a multidimensional database is organized in a ________ format.
cube
Big data analytics is usually associated with ________ services.
data warehouse
A ________ is a collection of related data that can be stored, sorted, organized, and queried.
database
A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.
range
In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.
real-time
If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.
redundancy
________ databases are the most commonly used electronic databases.
relational
SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.
relational algebra
Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.
unstructured
A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.
warehouse
