MIS Chapter 6

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

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

The three statements reflecting the business advantages of a relational database

1. reduced information redundancy 2. Increased information security 3. Increased information integrity

A(n)____ -driven website is an interactive website kept updated and relevant to the needs of its customers using a database

A data-driven website

A(n) ______ integration takes information entered into a given system and sends it automatically to all downstream systems and processes

A forward integration

This is a field (or group of fields) that identifies a given record in a table

A primary key

A (n) ______ is a collection of related data elements

A record

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

A relational database management system

Three advantages of a data-driven website

1. Easy to store large amounts of data 2. Easy to manage content 3. Easy to eliminate human errors

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

Content editor

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

Data latency

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

Data stewardship

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

Database

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

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

Identity management

This 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 storage of the same data in multiple places

Information redundancy

What allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems?

Integrations

What are rules that help ensure the quality of information?

Integrity constraints

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

Physical view of information

immediate, up-to-date information is?

Real-time information

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

Static information

What reflects a database

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

What is the smallest or basic unit of information

data element

Business-critical integrity constraints

tend to mirror the very rules by which an organization achieves success

The four primary reasons low-quality information occurs in the system

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

What are the data elements associated with an entity?

Attributes

The Three terms for the data elements associated with an entity

Attributes, Columns, Fields

What takes information entered into a given system and sends it automatically to all upstream systems and processes?

Backward integration

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

Business Critical integrity constraints

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

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

Content creator

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

Create data, Read data, Update data, Delete data

A data _______ compiles all the metadata about the data elements in the data model

Data Dictionary

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

Data_____ refers to the overall management of the availability, usability, integrity, and security of a company data

Data Governance

Synonym for data element

Data field

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

Data models

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

This includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data

Data validation

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

Database management system

What defines the relationship between entities and attributes in a relational database

Each attribute of an entity occupies a separate column of a table. Each record occupies one row

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

Entity

What 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 key

What focuses on how individual users logically access information to meet their own particular business needs?

Logical view of information

This 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

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

Query-by-example

Real time information in response to requests

Real-time systems

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

Relational Database model

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

Relational integrity constraints

A(n)______ query language asks users to write lines of codes to answer questions against a database

Structured query language

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

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

One of the primary goals of a database is to eliminate data redundancy by recording each piece of data in_______ place in the database.

only one