Chapter 1: DB 2

data warehouse

A _________ focuses primarily on strong data used to generate information required to make tactical or strategic decisions.

Database

A ____________ system is a composed of software, hardware, data, procedures, and people?

anomaly

A data __________ develops when all of the required changes in the redundant data are not made successfully?

distributed

A database that supports data distributed across several different sites is called a(n) _______ database.

set of one or more fields

A record consists of a ________________?

Desktop

A single-user database that runs on a personal computer is called?

non-procedural language

A(n) _________ allows users to specify what must be done without specifying how it must be done?

Information

Accurate, relevant, and timely ______ is the key to good decision making.

tuning

Activities that make the database perform more efficiently in terms of storage and access to speed are known as performance __________?

Record

All fields for a specific entity can be grouped together as a ____________?

spur of the moment question

An ad hoc query is a _________?

Transaction

Another name for a production database is a _________ database?

data dependence

Because all data access programs are subject to changes when any of the file's data storage characteristics change ( that is, changing the data type), the file system is said to exhibit____________?

independence

Data ______ exist when it is possible to make changes in the data storage characteristic without affecting the application program's ability to access the data?

the proper generation, storage, and retrieval of information.

Data management is a discipline that focuses on ......

the need to track data and produce required reports

Data processing (DP) specialists are in existence because of ________?

redundancy

Data______ exist when the same data are stored unnecessarily at different places?

create a new query

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would__________?

Information

Processed data, or ___________, can be used as the foundation for decision making.

query language

The DBMS allows users to specify what must be done, without having to specify how it is done, by using a(n) _______?

DBMS

The __________ receives ll application request and translates them into the complex operations required to fulfill requests.

data warehouse

The design of a __________ database recognizes the use of historical and aggregated data?

it helps create an environment for end users to have more data.

What is the benefit of using a DBMS?

query result set

What is the name for an answer to a query that the DBMS sends back to the application?

Metadata

What is the name for data about data?

MS Access

What of the following products do not provide an enterprise database?

data dictionary

Where does the DBMS store the definitions of data elements and their relationships?

End users

__________ are the people who use application programs to run the organization's daily operations?

Structural

__________ independence exist when it is possible to make changes in the file structure without affecting the application program's ability to access the data?

Database designers

___________ are considered database architects.

Structural Query Language (SQL)

___________ is the de facto query language and data access standards supported by the majority of DBMS vendors?