Exam 7: Databases and Data Warehouses

Describe the uses of a composite key with an example.

The smallest piece of data is called a_________ .

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

_________are entered to manipulate data,including adding,deleting,and updating data.

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 _________.

The relational database model consists of_________ which are used to contain records.

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

Transactional data is copied into a _________,which is a separate data repository.

A _________is the general logical structure in which records are stored within a database and the method used to establish relationships among the records.

In the _________phase of transferring data from a transactional database to a data warehouse,the builders create the files from transactional databases and save them on the server that will hold the data warehouse.

What are the advantages to integrating SQL in a DBMS?

In the_________ phase of data warehousing,specialists compare the data in the data warehouses with the original data to confirm completeness.

The ability to limit users' views to only specific columns or records gives a(n) _________an advantage: the ability to implement security measures.

Inaccuracies affect data integrity.

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 inclusion of foreign keys to create join tables might cause considerable _________,a complexity that has not diminished the popularity of relational databases.

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

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

A join table combines data from two or more tables.

When building a new database,users must first build a_________ .