Exam 7: Databases and Data Warehouses

If your last and first name,as well as address and other details appear in the files of the department where you work as well as in the payroll file of the Human Resource department,there is duplication of data,or ____________________.

A schema describes the structure of the database being designed: the names and types of fields in each record type and the general relationships among different sets of records or files.

The inclusion of foreign keys to create join tables might cause considerable ____________________.

Multiple characters make up a record.

The larger the data warehouse,the larger the storage capacity,the greater the memory,and the greater the processing power of the computers that are needed.

A ____ is the field by which records in a table are uniquely identified.

Many ____ also allow a builder to positively indicate when a field is not unique,meaning that the value in that field might be the same for more than one record.

A(n)____ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.

Inaccuracies hurt data integrity.

The very fact that manipulation of the data requires a programmer is probably the greatest disadvantage of the ____.

The ____________________ uses the object-oriented approach to maintaining records.

What are the advantages to integrating SQL in a DBMS?

For some business needs you must use a(n)____________________,a combination of two or more fields that together serve as a primary key,because it is impractical to use a single field as a primary key.

One of the most useful manipulations of object-oriented databases (ODBs)is the creation of a new table from two or more other tables.

To link records from one table with records of another table,the tables must have at least one field in common,and that field must be a ____ field for one of the tables.

A(n)____ is unique if the value (content)in that field appears only in one record.

Often,the traditional file approach to storing data leads to low ____.

Discuss the security issues concerning databases.

A ____ can be maintained,for instance,for professors and students in a college database.

There are two phases involved in building a data warehouse from transactional data: extraction and transforming.