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
