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

1.      Review

2.      Evolution of database systems

a.      Manual file systems

b.      Computerized filing

i.           Data Processing Specialist DP

ii.           Descriptors

1.      Data

2.      Field

3.      Record

4.      File

c.      Perspectives

i.           DP - Manual Files

ii.           Users - felt separated from the data

d.      File system redux

e.      Problems with file systems

i.           Purposes

1.      Understand database development

2.      If problems are not known they can find their way into database

ii.           Problems

1.      Lengthy development times

2.      Difficulty of getting quick answers

3.      Complex system administration

4.      Lack of security

5.      Extensive programming

a.      Example pg 19

f.       Structural and data dependence

g.      Data redundancy

i.           Problems

1.      Poor data security

2.      Data inconsistency

a.      Integrity

3.      Data entry errors

4.      Data delivery errors

5.      Data anomalies

a.      Update anomalies

b.      Insertion anomalies

c.      Deletion anomalies

h.      Lack of design and data modeling skills

3.      Database systems

a.      DBMS

i.           Components

1.      Hardware

2.      Software

3.      People

4.      Procedures

5.      Data

ii.           Functions

1.      Data dictionary management

2.      Data storage management

3.      Data transformation and presentation

4.      Security management

5.      Multiuser access control

6.      Backup and recovery management

7.      Data integrity management

8.      Database access language and application programming interface

9.      Database communication interfaces

4.      Managing the database system

5.      Preparing for your career

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 3.pdf