CIS Chapter 11 Key Terms – Flashcards
72 test answers
Unlock all answers in this set
Unlock answers 72question
Business Intelligence Systems
answer
Systems used to analyze and interpret data in order to enable managers to make informed decisions about how best to run a business
Unlock the answer
question
Clickstream Data
answer
Software used on company websites to capture info about each click that user make as they navigate through the site
Unlock the answer
question
Completeness Check
answer
In a database, ensures that all required fields have been completed
Unlock the answer
question
Consistency Check
answer
In a database, compares the values of data in two or more fields to see if those values are reasonable
Unlock the answer
question
Database
answer
Digital collection of related data that can be stored, sorted, organized, and queried
Unlock the answer
question
Database Administrator (database designer)
answer
An information technology professional responsible for designing, constructing, and maintaining databases
Unlock the answer
question
Database Management System (DBMS)
answer
A specially designed application software used to create and mage databases
Unlock the answer
question
Data Dictionary (database schema)
answer
A map of a database that defines the features of the fields in the database
Unlock the answer
question
Data Inconsistency
answer
Data for a record being different in two different lists
Unlock the answer
question
Data Integrity
answer
When the data in a database is accurate and reliable
Unlock the answer
question
Data Mart
answer
Small slices of data warehouse grouped together and separated from the main body of data in the data warehouse so that related sets of data can be analyzed
Unlock the answer
question
Data Mining
answer
The process by which great amounts of data are analyzed and investigated. Objective is to spot significant patterns or trends within the data that would otherwise not be obvious
Unlock the answer
question
Data Redundancy
answer
Duplicated data in a list
Unlock the answer
question
Data Staging
answer
The act of formatting data from source databases before fitting it into a data warehouse. It consists of three steps: extraction, transformation, and storage
Unlock the answer
question
Data Type (field type)
answer
1) Describes the kind of data being stored at the memory location; each programming language has its own data types 2) In a database, indicates what type of data can be stored in a field and prevents the wrong type of data from being entered into the field
Unlock the answer
question
Data Warehouse
answer
A large-scale collection of data that contains and organizes in one place all the data from an organization's multiple databases
Unlock the answer
question
Decision Support System (DSS)
answer
Type of business intelligence system designed to help managers develop solutions for specific problems
Unlock the answer
question
Default Value
answer
Value a database automatically uses for a field unless the user enters another value
Unlock the answer
question
Detail Report
answer
Report generated by a management info system that provides a list of the transactions that occurred during a certain time period
Unlock the answer
question
Enterprise Resource Planning (ERP) System
answer
Business intelligence system that accumulates in a central location all information relevant to running a business and makes it readily available to whoever needs it to make decisions
Unlock the answer
question
Exception Report
answer
Report generated by management information system that shows conditions that are unusual or that need attention by system users
Unlock the answer
question
Expert System
answer
System that tries to replicate the decision-making processes of human experts in order to solve specific problems
Unlock the answer
question
Field
answer
The component of a database in which the database stores each category of information
Unlock the answer
question
Field Constraint
answer
Property that must be satisfied for an entry to be accepted into the field
Unlock the answer
question
Field Properties
answer
In an Access database table, the field name, data type, and other data elements
Unlock the answer
question
Field Size
answer
Defines the maximum number of characters that a field can hold in a database
Unlock the answer
question
Filter
answer
In a database, temporarily displays records that match certain criteria
Unlock the answer
question
Foreign Key
answer
In a relational database, the common field between tables that's not the primary key
Unlock the answer
question
Fuzzy Logic
answer
Enables the interjection of experiential learning into knowledge-based systems by allowing the consideration of probabilities
Unlock the answer
question
Information System
answer
System that includes data, people, procedures, hardware, and software that help in planning and decision making; a software-based solution used to gather and analyze information
Unlock the answer
question
Input Form
answer
Used to control how new data is entered into a shared database
Unlock the answer
question
Join Query
answer
A query used to extract data that's in two or more tables in a database
Unlock the answer
question
Knowledge-Based System
answer
Business intelligence system that provides intelligence that supplements the user's own intellect and makes the decision support system more effective
Unlock the answer
question
Management Information System (MIS)
answer
Type of business intelligence system that provides timely and accurate information that enables managers to make critical business decisions
Unlock the answer
question
Many-to-Many Relationship
answer
In a relational database, records in one table are related to multiple records in a second table, and vice versa
Unlock the answer
question
Metadata
answer
Data that describes other data
Unlock the answer
question
Model Management System
answer
Software that assists in building management models in decision support systems; an analysis tool that, through the use of internal and external data, provides a view of a particular business situation for the purposes of decision-making
Unlock the answer
question
Multidimensional Database
answer
Database that stores data from different perspectives, called dimensions, and organizes data in a cube format
Unlock the answer
question
Natural Language Processing (NLP) System
answer
Knowledge-based business intelligence system that enables users to communicate with computer systems using a natural spoken or written language instead of a computer programming language
Unlock the answer
question
Normalization
answer
Process to ensure data is organized most efficiently in a database
Unlock the answer
question
Numeric Check
answer
In a database, confirms that only numbers are entered in a field
Unlock the answer
question
Object-Oriented Database
answer
Database that stores data in objects rather than in tables
Unlock the answer
question
Object Query Language (OQL)
answer
A query language used by many object-oriented databases
Unlock the answer
question
Office Support System (OSS)
answer
A system designed to improve communications and assist employees in accomplishing their daily tasks
Unlock the answer
question
One-to-Many Relationship
answer
In a relational database, a record appears only once in one table while having the capability of appearing many times in a related table
Unlock the answer
question
One-to-One Relationship
answer
In a relational database, for each record in a table there's only one corresponding record in a related table
Unlock the answer
question
Online Analytical Processing (OLAP)
answer
Software that provides standardized tools for viewing and manipulating data in a data warehouse
Unlock the answer
question
Online Transaction Processing (OLTP)
answer
The real-time processing of database transactions online
Unlock the answer
question
Primary Key Field
answer
In a database, a field that has a value unique to a record
Unlock the answer
question
Query
answer
In a database, a way of retrieving information that defines a particular subset of data; can be used to extract data from one or more tables
Unlock the answer
question
Query Language
answer
A specially designed computer language used to manipulate data in or extract from a database
Unlock the answer
question
Range Check
answer
Ensures that the data entered into the field of a database falls within a certain range of values
Unlock the answer
question
Real-Time Processing
answer
The processing of database transactions in which the database is updated while the transaction is taking place
Unlock the answer
question
Record
answer
Group of related fields in a database
Unlock the answer
question
Referential Integrity
answer
In a relational database, a condition where, for each value in the foreign key table, there's a corresponding value in the primary key table
Unlock the answer
question
Relational Algebra
answer
Use of English-like expressions that have variables and operations, much like algebraic equations, to extract data from databases using Structured Query Language
Unlock the answer
question
Relational Database
answer
Database type that organizes data into related tables based on logical groupings
Unlock the answer
question
Relationship
answer
In a relational database, a link between tables that defines how the data is related
Unlock the answer
question
Select Query
answer
In Structured Query Language, displays a subset of data from a table (or tables) based on the criteria specified
Unlock the answer
question
Structured (analytical) Data
answer
Data such as "Bill" or "345" as opposed to unstructured data (see below)
Unlock the answer
question
Structured Query Language (SQL)
answer
Database programming language used to construct queries to extract data from relational databases; one example of a fourth-generation language
Unlock the answer
question
Summary Report
answer
Report generated by a management information system that provides a consolidated picture of detailed data; these reports usually include some calculation or visual displays of information
Unlock the answer
question
Table (file)
answer
Group of related records in a database
Unlock the answer
question
Time-Variant Data
answer
Data that doesn't pertain to one period in time
Unlock the answer
question
Transaction-Processing System (TPS)
answer
Type of business intelligence system for keeping track of everyday business activities
Unlock the answer
question
Unstructured Data
answer
Audio clips, video clips, pictures, and extremely large documents. Also called binary large object (BLOB) (see above)
Unlock the answer
question
Validation
answer
The process of ensuring that data entered into a field of a database meets specified guidelines
Unlock the answer
question
Validation Rule
answer
In a database, generally defined as part of the data dictionary and specified in the filed properties for each field; violations result in an error message and a suggested action
Unlock the answer
