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
Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks
Characteristics of High-Quality Info
Accurate, Complete, Consistent, Unique and Timely.
an organized collection of data for one or more uses, typically in digital form.
Types of Databases
Hierarchical, Network and Relational.
Deals with the physical storage of information on a storage device.
Focuses on how individual users logically access information to meet their own particular business needs.
Refers to how well a system can adapt to increased demands.
Measures how quickly a system performs a certain process or transaction.
measures the quality of information.
rules that help ensure quality of information.
A person, place, thing, transaction, or event about which information is stored.
The data elements associated with an entity.
A collection of related data elements.
A field (or group of fields) that uniquely identifies a given entity in a table.
A primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables.
An interactive website kept constantly updated and relevant to the needs of its customers using a 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
define field lengths, decimal places etc. for data in tables and fields
Structured Query Language (SQL)
First commercial language for accessing data in relational databases, uses series of predefined commands to define data to be pulled out.
Query By Example (QBE)
Uses a graphical user interface that allows users to write queries by creating example tables on the screen.
A logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
Process of analyzing data to extract information not offered by the raw data alone.
Data Mining Tools
use variety of techniques to find patterns and relationships in large volumes of information. EX. Classifications, Estimation, Affinity grouping and clustering.
Need essay sample on "MIS Test 2 Chapter 6"? We will write a custom essay sample specifically for you for only $ 13.90/page