6.A Smart Book

Match the information type on the left with its correct definition on the right. 1. transactional information 2. analytical information

1. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. 2. Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks.

Select the four functions that a database management system can perform on data in a database?

> read data > update data > delete data > create data

Select the three accurate statements reflecting the business advantages of a relational database.

> reduced information redundancy > increased information security > increased information integrity

Integrity __________ are rules that help ensure the quality of information.

constraints

Who is the person responsible for creating the original website content?

content creator

Who is the person responsible for updating and maintaining website content?

content editor

A content _________ is the person responsible for creating the original website content.

creator

What is the smallest or basic unit of information?

data element

Select a term that is a synonym for data element, the smallest or basic unit of information in a database.

data field

What occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist?

data gap analysis

What refers to the overall management of the availability, usability, integrity, and security of company data?

data governance

What is the time it takes for data to be stored or retrieved?

data latency

What are logical data structures that detail the relationships among data elements using graphics or pictures?

data models

What is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

data stewardship

A(n) ____ maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

database

What maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?

database

What creates, reads, updates, and deletes data in a database while controlling access and security?

database management system

__________ (one word) information includes data that change based on user actions.

dynamic

What is an area of a website that stores information about products in a database?

dynamic catalog

What includes data that change based on user actions?

dynamic information

What is stored in a dynamic catalog, or an area of a website that stores information about products in a database?

dynamic website information

A content ________ is the person responsible for updating and maintaining website content.

editor

Select the term that refers to the table used to store information about a person, place, thing, transaction, or event.

entity

What stores information about a person, place, thing, transaction, or event?

entity

A data ______ analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

gap

Data ___________ refers to the overall management of the availability, usability, integrity, and security of company data.

governance

Information ___________ refers to the extent of detail within the information (fine and detailed or coarse and abstract).

granularity

___________ management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

identity

What is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

identity management

Information ___________ occurs when the same data element has different values.

inconsistency

What refers to the extent of detail within the information?

information granularity

What occurs when the same data element has different values?

information inconsistency

What is a measure of the quality of information?

information integrity

What occurs when a system produces incorrect, inconsistent, or duplicate data?

information integrity issues

What is the duplication of data, or the storage of the same data in multiple places?

information redundancy

Information _________ is a measure of the quality of information.

integrity

What are rules that help ensure the quality of information?

integrity constraints

Data _______ is the time it takes for data to be stored or retrieved.

latency

What provides details about data?

metadata

_________ provides details about data.

metadata

Data ____ are logical data structures that detail the relationships among data elements using graphics or pictures.

model

The ____________ view of information deals with the physical storage of information on a storage device.

physical

Which of the following deals with the physical storage of information on a storage device?

physical view of information

A(n) ____ key is a field (or group of fields) that uniquely identifies a given record in a table.

primary

What is a field that uniquely identifies a given record in a table?

primary key

A(n) ___________ -by-example tool helps users graphically design the answer to a question against a database.

query

Which tool helps users graphically design the answer to a question against a database?

query-by-example

__________ -time information means immediate, up-to-date information.

real

What means immediate, up-to-date information?

real-time information

Information __________ is the duplication of data, or the storage of the same data in multiple places.

redundancy

__________ integrity constraints are rules that enforce basic and fundamental information-based constraints.

relational

What are rules that enforce basic and fundamental information-based constraints?

relational in integrity constraints

__________ information includes fixed data incapable of change in the event of a user action.

static

What includes fixed data incapable of change in the event of a user action?

static information

Data ___ is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

stewardship

A(n) __________ query language asks users to write lines of code to answer questions against a database.

structured

What is the tool that consists of lines of code (in contrast to a graphical design) for answering questions against a database?

structured query language

When do information integrity issues occur?

when a system produces incorrect, inconsistent, or duplicate data