22 terms

Valuing Organizational Information

Chapter 6
STUDY
PLAY
Information Granularity
refers to the extent of detail within the information (fine and detailed or coarse and abstract)
Transactional Information
encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks. Ex: Withdrawing cash from an ATM, making an airline reservation, purchasing stocks.
Analytical Information
Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks. Ex: Trends, sales, product statistics, and future growth predictions.
Real-Time information
immediate, up-to-date information
Accuracy
Are all the values correct? For example, is the name spelled correctly? Is the dollar amount recorded properly?
Completeness
Are any of the values missing? For example, is the address complete including street, city, state, and zip code?
Consistency
Is aggregate or summary information in agreement with detailed information? For example, do all total fields equal the true total of the individual fields?
Uniqueness
Is each transaction, entity, and event represented only once in the information? For example, do all total fields equal the true total of the individual fields?
Timeliness
Is the information current with respect to the business requirements? For example, is information updated weekly, daily, or hourly?
Relational Database.
A type of database that stores information in the form of logically related two-dimensional tables.
Entity
A person, place, thing, transaction, or event about which information is stored.
Example: Customer, Order, Order Line, Product, Distributor
Attribute
Also called fields or columns. Characteristics or properties of an entity class. Example: Customer ID, Customer Name, Contact Name, and Phone
Primary Key
A field or group of fields that uniquely identifies each entity in the table and is the primary key. They are important because they provide a way of distinguishing each entity in a table
Foreign Key
In the Relational database model 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.
Physical View
Deals with the physical storage of information on a storage device such as a hard disk
Logical View
Focuses on how users logically access information to meet their particular business needs.
Relational Integrity Constraints
Rules that enforce basic and fundamental information-based constraints.
Business-Critical Integrity Constraints
enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints
DBMS
Database Management System: Software through which users and application programs interact with a database. The user sends requests tot eh DBMS and the DBMS performs the actual manipulation of the information in the database.
Integration
Allows separate systems to communicate directly with each other
Forward Integration
takes information entered into a given system and sends it automatically to all downstream systems and processes
Backward Integration
takes information entered into a given system and sends it automatically to all upstream systems and processes