refers to the extent of detail within the information (fine and detailed or coarse and abstract)
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.
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.
immediate, up-to-date information
Are all the values correct? For example, is the name spelled correctly? Is the dollar amount recorded properly?
Are any of the values missing? For example, is the address complete including street, city, state, and zip code?
Is aggregate or summary information in agreement with detailed information? For example, do all total fields equal the true total of the individual fields?
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?
Is the information current with respect to the business requirements? For example, is information updated weekly, daily, or hourly?
A type of database that stores information in the form of logically related two-dimensional tables.
A person, place, thing, transaction, or event about which information is stored. Example: Customer, Order, Order Line, Product, Distributor
Also called fields or columns. Characteristics or properties of an entity class. Example: Customer ID, Customer Name, Contact Name, and Phone
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
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.
Deals with the physical storage of information on a storage device such as a hard disk
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
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.
Allows separate systems to communicate directly with each other
takes information entered into a given system and sends it automatically to all downstream systems and processes
takes information entered into a given system and sends it automatically to all upstream systems and processes