Chap 10 Database Mgt Sys

Chap 10 Database - Chapter 10 Databases and Information Management Data and Information Computers process data and produce information Data

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 10 Databases and Information  Management
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data and Information Computers process  data  and produce  information. Data Collection of raw  unprocessed facts,  figures, symbols Not organized and  have little meaning  individually Information Data that is  organized,  meaningful, useful
Background image of page 2
Qualities of Valuable Information Information requires certain characteristics to  make it useful: Accurate Verifiable Timely Organized to suit users needs Meaningful to the person who will use it Accessible when needed Cost-effective
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database Set of data organized so that it is easily accessed Database Management System (DBMS) Software designed to create and access databases Add, change, delete, sort, retrieve, create forms and reports DBMS increases Data Integrity Degree to which the data is correct and trustworthy Promotes reliable data entry - GIGO Promotes data access in a timely manner Businesses rely on accurate, timely data to make good decisions  and take action Databases
Background image of page 4
Hierarchy of Data Data is built in layers, classified in a hierarchy Character -  A digit, letter or symbol stored in a byte Field -  Smallest unit of data user accesses Collection of characters that is given a  name, data type and maximum size Record -  Collection of related fields about a particular  entity Each record contains the same fields Key field/primary key Data File -  Collection of related records stored on  permanent media Database -  Collection of related data files
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Hierarchy of Data
Background image of page 6
Approaches to Store and Manage Data Two major approaches to store and manage data File Processing Approach Database Approach File Processing Systems Each department/area has its own set of files Designed for their own set of applications programs Disadvantages Data redundancy Isolated data
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Approaches to Data Managment File Processing Approach Data held in unrelated files, e.g. separate  departments hold separate files Resulted in redundant copies of data Program – data dependence Isolated data, incompatible formats
Background image of page 8
Approaches to Store and Manage Data The Database Approach Many applications programs and users use data  stored in a single shared database Advantages Reduced data redundancy Improved data integrity Shared data Improved data security Reduced application development time Easier reporting Disadvantages Cost Vulnerability
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Approaches to Store and Manage Data   File Processing Versus Database Application
Background image of page 10
Database Management Systems Personal computer, midrange  server, mainframe IBM Corporation
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/17/2008 for the course BUS ADM 230 taught by Professor Kasum during the Fall '07 term at Wisconsin Milwaukee.

Page1 / 31

Chap 10 Database - Chapter 10 Databases and Information Management Data and Information Computers process data and produce information Data

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online