Info Systems Ch. 5

____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization. Select one: a. Data selecting b. Enterprise data modeling c. Data cleansing d. Social graph analysis

Enterprise data modeling

_____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization. Select one: a. Business intelligence matrices b. Social graphs c. Key performance indicators (KPIs) d. Dashboards

Key performance indicators (KPIs)

______ is a form of database processing that supports top-down, query-driven data analysis. Select one: a. Database normalization b. Online analytical processing (OLAP) c. Data warehousing d. Data mining

Online analytical processing (OLAP)

The smallest piece of data used by a computer is a(n) _____. Select one: a. entity b. byte c. bit d. character

bit

Briefly describe the hierarchy of data.

bits, characters, fields, records, files, and database

The term _____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers. Select one: a. data loss prevention b. trade secret c. counterintelligence d. competitive intelligence

counterintelligence

The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization. Select one: a. data analyst b. data administrator c. database administrator d. data owner

data administrator

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports. Select one: a. primary key b. file c. foreign key d. data attribute

data attribute

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database. Select one: a. data dictionary b. schema c. data definition language d. data manipulation language

data definition language

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making. Select one: a. data dictionary b. data model c. data mart d. data mine

data mart

Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them. Select one: a. data mining b. online analytical processing c. data visualization d. predictive analysis

data visualization

Each attribute in a relational database model can be constrained to a range of allowable values called a _____. Select one: a. bandwidth b. scope c. slot d. domain

domain

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions. Select one: a. roll up b. drill down c. slice and dice d. extract data

drill down

A database is a collection of integrated and related _____. Select one: a. fields b. attributes c. records d. files

files

A _____ is a simple database program whose records have no relationship to one another. Select one: a. flat file b. schema c. relational system d. user view

flat file

A collection of fields all related to a single object, activity, or individual is a(n) _____. Select one: a. record b. file c. attribute d. character

record

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user. Select one: a. query b. record c. schema d. field

schema

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria. Select one: a. selecting b. joining c. projecting d. linking

selecting

Explain entity-relationship (ER) diagrams.

A datamodel that use basic graphical symbols to show the organization of/and relationships between data.

____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them. Select one: a. Data warehouse b. Data mart c. Big data d. Knowledge base

Big data

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse. Select one: a. Data mining b. Counterintelligence c. Competitive intelligence d. Enterprise data modeling

Data mining

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. Select one: a. Internet access b. Database as a Service c. Software as a Service d. Oracle

Database as a Service

Which of the following statements is true of a database? Select one: a. It is accessed primarily for use by an organization's database administrator and data administrator. b. It provides an essential foundation for an organization's knowledge management and artificial intelligence systems. c. It is a collection of unstructured data. d. It helps companies analyze information to open new market opportunities.

It helps companies analyze information to open new market opportunities.

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events. Select one: a. Business intelligence b. Social graph analysis c. Online analytical processing d. Predictive analysis

Predictive analysis

Some databases use ______, which is a visual approach to developing queries and requests. Select one: a. Query by Example (QBE) b. user views c. Structured Query Language (SQL) d. data manipulation language (DML)

Query by Example (QBE)

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database. Select one: a. Query by Example (QBE) b. Access c. Structured Query Language (SQL) d. Java

Structured Query Language (SQL)

A(n) _____ is a field or set of fields in a record that uniquely identifies the record. Select one: a. attribute b. entity c. primary key d. data item

primary key