51 terms

Management Information Systems

Chapter 6 Study Guide
Which of the following is NOT one of the main problems with a traditional file environment?
program-data independence
What are some problems with the traditional file environment?
data redundancy and inconsistency, program-data dependence, inflexibility, poor data security, and an inability to share data among applications
A DBMS reduces data redundancy and inconsistency by
minimizing isolated files in which the same data are repeated.
Which of the following best illustrates the relationship between entities and attributes?
the entity CUSTOMER with the attribute PURCHASE
A characteristic or quality describing an entity is called a(n)
Which of the following non-digital data storage items is most similar to a database?
library card catalog
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources
data redundancy
Duplicate data in multiple data files is called data ________.
A DBMS makes the
physical database available for different logical views.
The logical view
presents data as they would be perceived by end users.
DBMS for midrange computers include all of the following EXCEPT
Microsoft Access.
The type of logical database model that treats data as if they were stored in two-dimensional tables is the
relational DBMS.
Oracle Database Lite is a(n)
DBMS for small handheld computing devices.
Microsoft SQL Server is a(n)
DBMS for midrange computers.
In a table for customers, the information about a single customer would reside in a single
In a relational database, a record is referred to in technical terms as a(n)
A field identified in a table as holding the unique identifier of the table's records is called the
key field
A field identified in a record as holding the unique identifier for that record is called the
primary key
In a relational database, the three basic operations used to develop useful sets of data are
select, join, and project.
The select operation
creates a subset consisting of all records in the file that meet stated criteria.
The join operation
combines relational tables to provide the user with more information than is otherwise available.
The project operation
creates a subset consisting of columns in a table.
Which of the following database types is useful for storing java applets as well as processing large numbers of transactions?
The type of database management approach that can handle multimedia is the
object-oriented DBMS.
The data dictionary serves as an important data management tool by
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the
data dictionary
The specialized language programmers use to add and change data in the database is called
a data manipulation language.
The most prominent data manipulation language today is
DBMSs typically include report-generating tools in order to
display data in an easier-to-read format.
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called
A schematic of the entire database that describes the relationships in a database is called a(n)
entity-relationship diagram
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends with
two short marks
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with
a crow's foot topped by a short mark.
In what type of a database system is the entire central database duplicated at all remote locations?
Which of the following is a main disadvantage to a distributed database system?
susceptibility to data inconsistency
A data warehouse is composed of
historic and current internal data.
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because
a data mart typically focuses on a single subject area or line of business.
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as
business intelligence
he tool that enables users to view the same data in different ways using multiple dimensions is
OLAP is a tool for enabling
users to obtain online answers to ad-hoc questions in a rapid amount of time
Data mining is a tool for allowing users to
find hidden relationships in data
In terms of data relationships, associations refers to
occurrences linked to a single event.
________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
Text mining
An alternative to using application server software for interfacing between a Web server and back-end databases is
he organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)
information policy.
The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called
database administration.
Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising?
data redundancy
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called
data scrubbing.
As discussed in the Interactive Session: Technology, what problem was MySpace facing in its data management?
Data cleansing not only corrects errors but also
Data cleansing not only corrects errors but also
Which of the following is NOT a method for performing a data quality audit?
surveying data definition and query files