Exam 7: Databases and Data Warehouses

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

Much of the extraction,transforming,and loading (ETL) activity involved in data transfer can be automated.

_________helps the users know what they can find and analyze in the data warehouse.

Database management systems structure files,store data,and link records.

Multiple characters make up a record.

A(n)_________ includes a description of a database's structure,the names and sizes of the fields,and details such as which field is a primary key.

A repeated field that links records between two tables,is a primary key in one table,and a(n) _________in the other field.

The three phases involved in building a data warehouse from transactional data are extraction,transforming,and loading.

_________involves high volumes of data compiled from traditional,ordinary business activities,as well as newer,nontraditional sources.

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.