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