Exam 7: Databases and Data Warehouses

A(n)____________________ creates a temporary table that is a subset of the original table or tables.

To uncover the valuable information contained in their data,organizations must use software that can effectively "____" data warehouses.

Usually,a table in a relational database must have a primary key,and most relational DBMSs enforce this rule.

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the ____,which does have this mechanism.

Organizations often organize their data warehouse as a collection of ____________________,smaller collections of data that focus on a particular subject or department.

Because of capacity needs,organizations often choose ____ to store and manage data warehouses.

What are the main features of maintenance of a relational database?

While a transactional database contains current data,which is disposed of after some time,the data in ____ is accumulated and might reflect many years of business activities.

Unlike ____________________,transactional databases are usually not suitable for business analysis because they contain only current,not historical,data.

Effective ____ and design of each database involves the creation of a conceptual blueprint of the database.

To design a(n)____,you need a clear idea of the different entities and how they relate.

____ should first be done to decide which data should be collected and how it should be organized.

Databases are stored on and processed from ____ storage devices,such as magnetic disks or DVDs.

From a technical point of view,online databases that are used with Web browsers are different from other databases.

____ do not replace transactional databases,which are updated with daily transactions such as sales,billing,cash receipts,and returns.

The only way for organizations to conduct some Web-based businesses is to give people outside the organizations access to their ____________________.

The impact of database technology on business can be easily overstated.

Once the data warehouse is in operation,much of the ETL activity can be automated.

____________________ has become the query language of choice for many developers of relational DBMSs.

Explain the impact of databases on businesses.