Advertisement Upgrade to remove ads

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)

attribute

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 ________.

redundancy

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

row

In a relational database, a record is referred to in technical terms as a(n)

tuple

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?

OODBMS

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

SQL

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

normalization

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?

replicated

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

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

CGI

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?

scalability

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set