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. A data dictionary is an automated or manual tool for storing and organizing information about the data maintained in a database. A data dictionary refers to documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning.

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

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

__________ 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

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 You've probably used Hadoop 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 is an open-source software framework that enables distributed parallel processing of huge amounts of data across many inexpensive computers. It 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.

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

Normalization

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?

Relational database products are powerful partly because they are available as cloud computing services. Each table in a relational database contains a key field to uniquely identify each record for retrieval or manipulation. -----> The relational database has become the primary method for organizing and maintaining data in information systems because it is so rigidly controlled. Relational database tables can be combined easily to deliver data required by users, provided that any two tables share a common data element.

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.

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.

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.

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 column represents __________.

an attribute or a field

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 This central repository of information is referred to as a data warehouse. A data warehouse is a central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning. The ability to draw high-quality information from an organization's databases to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategy is critical to the stakeholders of any organization.

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

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.

Entity

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

__________ 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

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

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.

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?

-Using data cleansing software -----> Using in-memory computing <------ -Using enterprise-wide data standards -Using databases designed to minimize inconsistent and redundant data -Perform data quality audits ------> Use data mining <------ A firm would not use in-memory computing to make sure they have a high level of data quality. In-memory computing is technology for the very rapid analysis and processing of large quantities of data by storing the data in the computer's main memory rather than in secondary storage. A firm should use enterprise-wide data standards to make sure they have a high level of data quality. A firm should use databases designed to minimize inconsistent and redundant data to make sure they have a high level of data quality. A firm should use data cleansing software to make sure they have a high level of data quality.

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. It's false that the relational database has become the primary method for organizing and maintaining data in information systems because it is so rigidly controlled. In fact, the relational database has become the primary method for organizing and maintaining data in information systems because it is so flexible and accessible. It's true that relational database tables can be combined easily to deliver data required by users, provided that any two tables share a common data element. It's true that each table in a relational database contains a key field to uniquely identify each record for retrieval or manipulation. It's true that relational database products are powerful partly because they are available as cloud computing services.