Data

Copy and paste the text below. It is read-only. Select All

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