Topic 1 Database Systems MODULE 1 1 DATA

Topic 1 : Database Systems MODULE 1. 1: DATA VS INFORMATION

DATA -> INFORMATION -> DECISIONS Point #1

Data are raw facts Unprocessed, thus, no meaning

Information Processed Data: reveals different meaning If we are given accurate, relevant and timely information, we are able to create good decisions. Knowledge and Wisdom!

Data->Information>Decision Data constitutes the building blocks of information Information is produced by processing data Information is used to reveal the meaning of the data Accurate, Relevant and timely information is the key to good decision making Good decision making is the key to organizational survival in the global environment

As an IM student… We MANAGE INFORMATION. We collect the data, able to process the data accurately to create useful information Thus, you should learn how to manage these chunks of information A system used is databasing.

DATABASE AND THE DBMS Point #2

What is a Database? A Database is a shared, integrated computer structure that stores a collection of 1. End-user data: RAW DATA 2. Meta. Data

What is a Meta data? Provide a description of the data characteristics and the set of relationships that link the data found within the database.

A database… A database resembles a very-organized electronic filing cabinet in which a powereful software, known as a database management system, helps manage the cabinet’s A Database Management System (DBMS) is a collection of programs that manage the database structure and controls access to the data stored in the database. An information system is a system that collects and stores data

Data we need to manage: Supermarket – invemtory & checkout Credit card – purchases & cash advance Automated teller machines – deposits, withdrawals & balance inquiry Travel agent – booking, reservation & ticketing Library – catalog, loans & returns Insurance – customer information University – student information

Databases and Information Systems Strategic Databases Decision support systems Management information systems Database Management System (DBMS) Management Databases Transaction processing systems Transaction Databases “Information Resources Management”

Steps Involved in Converting Data to Information DATA INFORMATION ACQUISITION DISTRIBUTION STORAGE RETRIEVAL MANIPULATION

What is a database management system (DBMS)? • software package/ system to facilitate the creation and maintenance of a computerized database. • It defines (data types, structures, constraints) construct (storing data on some storage medium controlled by DBMS) and manipulate (querying, update, report generation) databases for various applications.

Use of Database Improved data sharing Better data integration Minimize data inconsistency and redundancy Improved data access.