Exam 4: Managing Information Resources with Databases

Information that cannot be linked together is called ________.

Data stewards ensure that people adhere to the definitions for the master data in their organizational units.

A database administrator adds demographic data from the U.S. Census Bureau to the company's customer records with zip codes before loading it into the data warehouse. This process is called the ________.

Shadow systems focus on ________.

The database performance tuning process takes into account ________.

To balance the information needs of multiple stakeholders, top-level managers need clear, consistent, and accurate reports that summarize information from across the enterprise.

An approach that addresses the underlying inconsistencies in the way people use data by attempting to achieve consistent and uniform definitions for entities and their attributes across all business units is called ________.

The early file processing systems were very difficult to maintain because of ________.

A person who ensures that people adhere to the definitions for the master data in their organizational units is called a(n) ________.

While creating a relational database for an organization, "Employees" would constitute one attribute with entities such as employee ID number, last name, first name, birth date, e-mail address, and phone number.

Batch processing is defined as ________.

Smaller databases developed by individuals or departments that focus on their creator's specific information requirements are known as ________.

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning is called a ________.

The database model that organizes information into tables of records that are connected to one another by linking a field in one table to a field in another table with matching data is called ________.

Databases are created and managed using ________.

What approach do database developers use while choosing primary keys for the data model?

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

How does metadata differ for different types of information?

A company maintains a centralized repository of information from internal sources, competitor information, census reports, metadata from documents and multimedia, and other information. This is known as a ________.