Exam 1: The Database Approach

Historically, a manual file system was composed of a system of file folders and filing cabinets.

Metadata present a more complete picture of the data in the database than the data itself.

A workgroup database is a(n)____ database.

A query language is a procedural language.

A(n) ____ database is used by an organization and supports many users across many departments.

Most decision-support data are based on historical data obtained from ____.

The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.

A data warehouse can store data derived from many sources.

What are the advantages of having the DBMS between the end user's applications and the database?

Corporations use only structured data.

What are some reasons for studying file systems?

____ data exist in a format that does not lend itself to processing that yields information.

The term _________________________ refers to scattered locations storing the same basic data.

Discuss some considerations when designing a database.

____________________ exists when the same data are stored unnecessarily at different places.

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Most data you encounter is best classified as ____.

A(n) ___________________________________ is a collection of programs that manages the database structure and controls access to the data stored in the database.

XML data is ____.