Which of the following is NOT one of the main problems with a traditional file environment?
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
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
The type of logical database model that treats data as if they were stored in two-dimensional tables is the
A field identified in a table as holding the unique identifier of the table's records is called the
A field identified in a record as holding the unique identifier for that record is called the
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.
Which of the following database types is useful for storing java applets as well as processing large numbers of transactions?
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
The specialized language programmers use to add and change data in the database is called
a data manipulation language.
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)
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 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
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
________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
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)
The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called
Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising?
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called
As discussed in the Interactive Session: Technology, what problem was MySpace facing in its data management?