CIS 205 Chapter 6.1

Which of the following represent the five common characteristics of high-quality data?

-Accurate -Complete -Consistent -Timely -Unique

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

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

Which of the following represent analytical data?

-Future growth forecasts -Product Statistics -Trends -Sales projections

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

-Increased data integrity -Reduced data redundancy -Increased data security

Which of the following are the business advantages of a relational database?

-Increased flexibility -Increased scalability -Reduced data redundancy -Increased data integrity

Which of the following represent the data levels in an organization?

-enterprise -department -individual

What are the primary concepts of a relational database model?

-entities -attributes -primary key -foreign key

1.Transactional data 2.Analytical data

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

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

1.Is there an incorrect value in the data? 2.Is a value missing from the data? 3.Is aggregate or summary data in agreement with detailed data? 4.Is the data current with respect to business needs? 5.Is each transaction and event represented only once in the data?

A(n) _________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Business

__________ critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Business

What is the ultimate outcome of a data warehouse?

Data Marts

What is the smallest or basic unit of data?

Data element

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

Data field

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

Data integrity issues

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

Select the four primary traits of the value of data.

Data timeliness Data quality Data governance Data type

What maintains data 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

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.

Which data element stores a single piece of data about a person, place, thing, transaction, or event?

Entity

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

Granularity

What are rules that help ensure the quality of data?

Integrity constraints

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

Latency

Identity ____________ is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Management

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 systems?

Master data management

___________ provides details about data.

Metadata

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

Physical view of data

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

Primary key

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

Query-by-example

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

Real

What is a collection of related data elements?

Records

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

Relational

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

Relational database model

Which of the following are examples of analytical data?

Sales projections Product statistics

Which of the following are examples of transactional data? (Check all that apply.)

Sales receipt Airline ticket

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

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

T/F: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True

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

Update data Read data Create data Delete data

When do data integrity issues occur?

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.

Why does a database offer increased information security?

Why does a database offer increased information security?

A data ____________ compiles all of the metadata about the data elements in the data model.

dictionary

Attributes are the data elements associated with an ________.

entity

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

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

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

inconsistency

Data _________ is a measure of the quality of data.

integrity

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

logical

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

models

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

only one

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

redundancy

A(n) __________ database management system allows users to create, read, update, and delete data in a relational database.

relational

Which constraint does not allow someone to create an order for a nonexistent customer?

relational integrity constraint

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

structured

Real-time __________ provide real-time data in response to requests.

systems

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

validation