Chapter 11 Checkpoint Flashcards
True or False: the more errors data contains, the higher its integrity
False
True or False: in a data hierarchy, each higher level of data contains one or more items from the lower level
True
True or False: a field size determines the maximum number of characters a field can contain
True
True or False: validity checks reduce data entry errors and thus enhance the data’s integrity
True
True or False: a check digit often confirms the accuracy of a primary key value
True
True or False: file processing systems require more memory, storage, and processing power than a database
False
True or False: in a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period
False
True or False: in a file processing system, you can set up a relationship between tables at any time
False
True or False: a relational database processes and summarizes large number of records efficiently and can do so much faster than a multidimensional database
False
True or False: a database administrator (DBA) focuses on the meaning and usage of data
False
True or False: an ERP allows for storage and management of a company’s documents
False
True or False: with batch processing, the computer collects data over time and processes all transactions later, as a group
True
A(n) ___________ check tests data in two or more associated fields to ensure that the relationship is logical and their data is in the correct format.
consistency
Which of the following is not an advantage of a database approach?
a. improved data integrity
b. reduced data redundancy
c. shared data
d. requires less memory, storage, and processing power than file processing systems
d. requires less memory, storage, and processing power than file processing systems
A _____ ________ contains data about each file in the database and each field in those files.
data dictionary
A developer of a relational database refers to a file as a ________.
relation
A(n) ______-_________ database stores data in objects.
object-oriented
With ________ __________ _________, the computer processes each transaction as it is entered.
online transaction processing
A(n) _________ report usually lists just transactions.
detailed
In an expert system, the __________ ______ is the combined subject knowledge and experiences of the human experts.
knowledge base
combination of one or more related characters or bytes and is the smallest unit of data a user accesses
field
specifies the kind of data a field can contain and how the field is used
data type
field that uniquely identifies each record in a file
primary key
procedures that keep data current
file maintenance
process of comparing data with a set of rules or values to determine if the data is correct
validation
request for specific data from a database
query
defines how users view the organization of the data
data model
item that contains data, as well as the actions that read or process the data
object
huge database that stores and manages the data required to analyze historical and current transactions
data warehouse
term used to describe the widespread growth of data, the variety of formats in which the data is available, and the processing required to make the data accessible in a timely manner
Big Data
What is function creep?
Function creep occurs when a company uses the technology intended for one purpose for another.
If you use a browser, what are some techniques you can use to protect your data?
1) using settings in the browser that will allow you to limit data tracking
2) read privacy policies before you purchase an item from an online vendor
3) use a social networking site that informs you of potential ways your data may be used
List reasons for backing up data.
1) before modifying or deleting data
2) before performing any maintenance operations on the database
List some ways to back up database.
1) If your computer already has a backup program running, it might be backing up your database. If not, configure the backup program to back up the database
2) Copy the database to another storage device
3) Copy the database to a different folder on the same storage medium as the original database
What are the responsibilities of database analysts and administrators?
The database analysts and administrators are responsible for managing and coordinating all database activities.
How do their jobs differ?
The database analysts, focuses on the meaning and usage of data.
- decide the proper placement of fields
- defines the relationships among data
- identifies users
- access privileges
The database administrator
- creates and maintains the data dictionary
- manages security of the database
- monitors the performance of the database
- checks backup and recovery procedures
What is database design?
the process of determining the organization of a database
In designing a database, what must the database analyst or administrator identify?
1) the entities in the database
2) the entities’ attributes, primary keys, and relationships
What is a decision support system?
helps users analyze information and make decisions
What is an expert system?
an information system that captures and stores the knowledge of human experts and then imitates human reasoning and decision making
