A ________ is a collection of related data that can be stored, sorted, organized, and queried. |
database |
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 |
Data ________ means that the data contained in a database is accurate and reliable. |
integrity |
Data ________ helps to ensure data integrity by maintaining information in only one place. |
centralization |
In a database, the term ________ is synonymous with a category of information. |
field |
In a database, a group of related records is referred to as a(n) ________. |
table |
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field. |
long text |
You can set a ________, which is automatically displayed in a field unless the user enters something different. |
default value |
Which of the following is a likely primary key in a student information record? |
student id number |
________ is used to ensure that data is organized most efficiently in a database. |
normalization |
________ databases are the most commonly used electronic databases. |
relational |
A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table. |
one-to-one |
________ 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 |
Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data. |
unstructured |
Data in a multidimensional database is organized in a ________ format. |
cube |
A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250. |
range |
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 would use a ________ in a database to temporarily display records of residents for the city of Boston. |
filter |
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 |
SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations. |
relational algebra |
________ 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 data ________ is a large-scale collection of data that contains and organizes all of an organization’s data in one place. |
warehouse |
Data staging consists of all of the following steps, EXCEPT ________. |
mining the data |
Big data analytics is usually associated with ________ services. |
data warehouse |
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 |
Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system. |
exception |
Siri, the personal assistant application on Apple’s iPhone is an example of a ________. |
natural language processing (NLP) system |
________ is the branch of computer science that attempts to create computers that think like humans. |
Artificial intelligence |
Data redundancy ensures that the data contained in the database is accurate and reliable. |
F |
Small slices of a data mart are called data warehouses. |
F |
A group of related records is called a table. |
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 |
When using Access, the text of the Declaration of Independence would be stored in a short text field. |
F |
Employees’ last names would usually make an appropriate primary key field. |
F |
Normalization means that there are no data entry errors in a database. |
F |
In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink. |
F |
A database schema defines the name, data type, and length of each field in the database. |
T |
A last name field is an example of a field that should have a default value. |
F |
Most databases can import electronic data from other software applications. |
T |
A filter is limited to extracting data from a single table. |
T |
The information in a data mart spans an entire enterprise. |
F |
Real-time processing means that transactions are updated when they occur. |
T |
A summary report generated by a MIS provides a list of the transactions that occurred during a specified time period. |
F |
Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends. |
T |
Chapter 11 TIA
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price