Exam 7: Databases and Data Warehouses

The description of each table structure and types of fields become part of a(n)____________________,which is a repository of information about the data and their organization.

The ability to limit users' views to only specific columns or records gives the ____________________ another advantage: the ability to implement security measures.

In the database approach,data pieces are organized about ____.

If ____ need to be used as one large data warehouse,special software tools can unify them and make them appear as one large data warehouse.

A unique key can serve as a(n)____________________.

The combined storage of both data and the procedures that manipulate them is referred to as ____.

While a database itself is a collection of several related files,the program used to build databases,populate them with data,and manipulate the data is called a(n)____________________.

When building a new database,users must first build a schema (from the Greek word for "____").

All relationships and the various needs for ____ must be taken into account when designing the database.

The designers of data warehouses must keep in mind ____: the ability of the data warehouse to grow as the amount of the data and the processing needs grow.

A collection of related records,such as all the records of a college's students,is called a(n)____.

The conceptual blueprint of the database is called an entity relationship diagram (ERD).

A data warehouse is a large,typically relational,database that supports management decision making.

A(n)____________________ is one piece of information about an entity,such as the last name or first name of a student,or the student's street address.

Analyzing an organization's data and identifying the relationships among the data is called ____________________.

Data is accessed in a database by sending messages called "protocols," which request data from specific records and/or fields and direct the computer to display the results.

A(n)____________________ is any object about which an organization chooses to collect data.

Object-oriented databases (ODBs)do not store records,but data objects,which is an advantage for quick updates of data sets and the relationships among them.

Sometimes a key is composed of several records so that their combination provides a unique key.

What does metadata include?