cts115 ch 6 ALL 1

Select the four primary traits of the value of information.

-Information quality - information type - information timeliness - information governance

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

-Reduced information redundancy. -Increased information integrity. -increased information security.

Which of the following represent the five common characteristics of high-quality information? (Check all that apply)

-accurate -complete -consistent -timely -unique

Analytical information

-sales projections - product statistics - future growth and trends

Transactional information

-sales receipt -airline ticket -packing slip

Five Characteristics Common to high quality information

1. Accurate 2. Complete 3. Consistent 4. Timely 5. Unique

What are the data elements associated with an entity?

Attributes

what defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Business rule

What compiles all of the metadata about the data elements in the data model?

Data dictionary

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 governace

Who is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business?

Data steward

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

True or false: Information in an organization exists only a few departments, such as sales and marketing

False

A(n) ____ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Foreign

___________ 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 the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational system?

Master data management

What provides details about data?

Metadata

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

Physical

What deals with the physical storage of information on a storage device?

Physical view of information

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

Primary key

What means immediate, up-to-date information?

Real-time information

What is a collection of related data elements?

Records

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

Relational integrity constraints

True or false: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True

True or false: Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.

True

Why does a database offer increased information security?

Various security features of databases ensure that individuals have only certain types of access to certain types of information.

data (information) integrity issues

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

Select the statement below that accurately reflects a database.

While a database has only one physical view, it can easily support multiple logical views that provides for flexibility.

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

data models

What takes a new approach to middleware by packaging commonly used applications together, reducing the time needed to integrate applications from multiple vendors?

enterprise application integration middleware.

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

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

granularity

What are rules that help ensure the quality of information?

integrity constraints

One primary goal of a database is to eliminate information redundancy by recording each piece of information in _______ place(s) in the database.

only one.

---- integrity constraint does not allow someone to create an order for a nonexistent customer.

relational

What stores information in the form of logically related two-dimensional tables?

relational database model.

Select the three terms for the data elements associated with an entity.

-Attributes -Columns -Fields

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

-Create data -Update data - Read Data -Delete Data

Select the four primary reasons low-quality information occurs in a system.

-Data-entry personnel enter abbreviated information to save time. - Online customers intentionally enter inaccurate information to protect their privacy. - Third-party and external information contains inconsistencies and errors. - Different systems have different information entry standards and formats.

Select the three advantages of a data-driven website.

-Easy to manage content -Easy to store large amounts of data -East to eliminate human errors.

What enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Business-critical integrity constraints

A(n) ___________ (one word) -driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Data

What is the collection of data from various sources for the purpose of data processing?

Data aggregation

What includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data?

Data validation

What is an interactive website that uses a database to constantly update in order to remain relevant to the needs of its customers?

Data-driven website

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

Information granularities

Detail, summary, aggregate

Information formats

Documents, presentations, spreadsheets, database

__________ (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 is stored in a dynamic catalog, or an area of a website that stores information about products in a database?

Dynamic website information

Select the statement that accurately defines the relationship between entities and attributes in a relational database.

Each attribute of an entity occupies a separate column of a table.

Transactional information

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.

Analytical information

Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks.

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

Information levels

Individual, department, enterprise

What refers to the extent of detail within the information?

Information granularity

Complete

Is a value missing from the information?

Consistent

Is aggregate or summary information in agreement with detailed information?

Unique

Is each transaction and event represented only once in the information?

Timely

Is the information current with respect to business needs?

Accurate

Is there an incorrect value in the information?

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

Latency

The __________ view of information focuses on how individual users logically access information to meet their own particular business needs.

Logical

__________ data management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational system.

Master

_________ provides details about data.

Metadata

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

Query

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

Relational

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

Data _______ includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Validation

Which of the following is correct in reference to a database?

a database can support many logical views.

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

inconsistency

Which of the following is a measure of the quality of information?

information integrity

When do information integrity issues occur?

when a system produces incorrect, inconsistent, or duplicate data.