Chapter 6 DSM

Which of the following best describes a data dictionary?

A data dictionary is an automated or manual tool for storing and organizing information about the data maintained in a database.

Which of the following best describes a data manipulation language?

A data manipulation language is associated with a database management system that end users and programmers use to manipulate data in the database.

Which of the following best describes a data quality audit?

A data quality audit is a structured survey of the accuracy and level of completeness of the data in an information system.

__________ would specify that only selected members of the payroll and human resources department would have the right to change sensitive employee data, such as an employee's salary and social security number, and that these departments are responsible for making sure that such employee data are accurate.

An information policy

Entity

An is another name for a table in a relational database.

Which of the following functions of an organization is responsible for information policy, as well as for data planning, data dictionary development, and monitoring data usage in the firm?

Data administration

Which of the following can be used to automatically enforce consistency among different sets of data?

Data cleansing

__________ is a type of intelligence gathering that uses statistical techniques to explore records in a data warehouse, hunting for hidden patterns and relationships that are undetectable in routine reports.

Data mining

You've probably used __________ to find the best airfare on the Internet, get directions to a restaurant, do a search on Google, or connect with a friend on Facebook.

Hadoop

__________ breaks a big data problem down into sub-problems, distributes them among up to thousands of inexpensive computer processing nodes, and then combines the result into a smaller data set that is easier to analyze.

Hadoop

Why is a relational DBMS so powerful?

Relational database products are available as cloud computing services.

Which of the following statements about the power of a relational DBMS is false?

The relational database has become the primary method for organizing and maintaining data in information systems because it is so rigidly controlled.

Data that are inaccurate, incomplete, or inconsistent create serious operational and financial problems for businesses because they create inaccuracies in product pricing, customer accounts, and inventory data, and lead to inaccurate decisions about the actions that should be taken by the firm. Which of the following is not a step a firm might take to make sure they have a high level of data quality?

Use data mining

Online analytical processing (OLAP) is best defined as __________.

the capability for manipulating and analyzing large volumes of data from multiple perspectives

Text mining

the discovery of patterns and relationships from large sets of unstructured data.

Server virtualization

the process of running two or more operating system instances on the same server. The host operating system runs virtual operating system instances as applications.

David creates a central database by extracting, transforming, and loading metadata from various internal and external sources of information. He plans to use this database for executing various functions such as intelligence gathering, strategic planning, and analysis. This central repository of information is referred to as a __________.

data warehouse

The __________ functions of an organization are responsible for defining and maintaining a database. These functions are performed by a database design and management group.

database administration

Data governance

deals with the overall policies and processes for managing the availability, usability, integrity, and security of the data employed in an enterprise.

Organizations perform data quality audits to __________.

determine accuracy and level of completeness of data

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information are specified by __________.

information policies

__________ involves the process of creating small, stable, yet flexible data structures from complex groups of data when designing a relational database.

Normalization

Data definition is __________.

a DBMS capability that specifies the structure and content of the database

Database Schema

a graphic that documents the data model and shows the tables, attributes, keys, and logical relationships for a database.

The relational database is the primary method for organizing and maintaining data today in information systems. It organizes data in two-dimensional tables with rows and columns called relations. In a database, __________ is used to uniquely identify each record for retrieval or manipulation.

a key field

Database Management System (DBMS)

a program used to create, process, and administer a database.

The relational database is the primary method for organizing and maintaining data today in information systems. It organizes data in two-dimensional tables with rows and columns called relations. In a database, each row represents __________.

a record

The relational database is the primary method for organizing and maintaining data today in information systems. It organizes data in two-dimensional tables with rows and columns called relations. In a database, each column represents __________.

an attribute or a field