CHAPTER 11 Flashcards
A column in a database in which customer names are stored would be referred to as a __________.
field
Fuzzy logic uses __________.
probablity
The field in a table that uniquely identifies each record in that table and relates that table to other tables is called the ___________.
primary key
Ray Kurzweil predicts the Singularity might occur by ____.
2045
A system designed to help keep track of everyday business activities is a(n) _____________.
Transaction Processing System
The world’s largest ERP software company is called
SAP
Big Data refers to
Large amounts of data generated today
Employees’ last name would usually make an appropriate primary key field.
False
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
Long text
________ 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
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.
bath processing
A(n) ________ check determines whether a required field such as LastName was filled in.
Completeness
Data ________ means that the data contained in a database is accurate and reliable.
redundancy
Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.
detail
Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.
exception
When is a flat database sufficient to use when organizing data?
When the data is simple and can be organized in one table
A customer information table linked to a password table in a business database reflects which type of relationship?
One-to-many
Many-to-one
Many-to-many
One-to-one
A process to ensure that data in a database is organized most efficiently is called
centralization.
data staging.
normalization.
integration.
Which of the following is not considered metadata?
Data type
Database name
Field name
Field size
Data captured as users navigate through a website is called
staged data.
web-user data.
time-variant data.
One-to-one
A process to ensure that data in a database is organized most efficiently is called
normalization
Which of the following is not considered metadata?
Database name
Data captured as users navigate through a website is called
stage data
The type of database that would be best to store and organize data with feature and measure attributes is which of the following?
Multidimensional database
Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use?
Query
Which of the following data-mining techniques is used to create charts and dashboards?
Visualization
