Title: Class Outline 2
Course: KVCC BUS210 > Section: Class Outlines

1.      Assignment 1

2.      Introduction to databases

a.      Why do we need databases?

3.      Data VS. Information

a.      Data - Raw Facts

b.      Information - Processing data to reveal its meaning

c.      Knowledge age

i.           "Data are the foundation of information, which is the bedrock of knowledge"

d.      Summary

i.           Data constitutes the building blocks of information

ii.           Information is produced by processing data

iii.           Information is used to reveal the meaning of data

iv.           Accurate, relevant, and timely information is key to good decision making

v.           Good decision making is the key to organizational survival in a global environment

4.      Database

a.      End user data

b.      Metadata

c.      DBMS - Database Management System

i.           Advantages

1.      Improved data sharing

2.      Improved data security

3.      Better data integration

4.      Minimized data inconsistencies

5.      Improved data access

6.      Improved decision making

7.      Increased End-User productivity

d.      Types of databases

i.           Single user database

1.      Desktop Database

ii.           Multiuser Database

1.      Workgroup - less than 50 users

2.      Enterprise - more than 50 users

iii.           Centralized

iv.           Distributed

v.           Cloud Database

vi.           General Purpose

vii.           Discipline Specific

viii.           Operational/Online Transaction Processing/Transactional/Production

ix.           Analytical

x.           Data warehouse

xi.           Online Analytical Processing

xii.           Business Intelligence

xiii.           Unstructured Data

xiv.           Structured Data

xv.           Semi-Structured Data

xvi.           Extensible Markup Language XML

xvii.           Social Media

1.      NoSQL

5.      Why database design is important

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 2.pdf