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

a.      Structural and data dependence

b.      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

c.      Lack of design and data modeling skills

1.      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

1.      Managing the database system

2.      Preparing for your career

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 4.pdf