Title: Class Outline 23
Course: KVCC_BUS205 > Section: Class Outlines

a.      DBMS

i.           Four Components

1.      Application Programming Interface (API)

2.      Direct SQL or Query Language

3.      An Administrative Interface

4.      Underlying Set of data access programs and subroutines

ii.           Data Access and Management Capabilities

1.      Multi user access at same time

2.      Access to data without writing programs

3.      Application of uniform and consistent access and content controls

4.      Integration of data stored on multiple servers distributed across multiple locations

b.      Data base design and Administration

i.           How does database design integrate into the business technology architecture

1.      Technology Environment

2.      Hardware and Network Architecture

ii.           How does database design integrate into the overall project plan

1.      Agile

2.      Phased deployment

iii.           Who is involved in database design

1.      Data Administrator

2.      Database Administrator

c.      Relational Databases

i.           RDBMS

ii.           Tables/relations

iii.           Row/tuple/record

iv.           Attribute/field

v.           Attribute value/field value/data element

vi.           Key

1.      Candidate Key

2.      Primary Key

3.      Foreign Key

vii.           Designing Relational Databases

1.      Create a table for each class in the domain model

2.      Choose a primary key for each table

3.      Add foreign keys to represent one-to-many associations

4.      Create new tables to represent many-to-many associations

5.      Represent and adjust classification hierarchies

6.      Define referential integrity constraints

7.      Evaluate schema quality and make necessary improvements

8.      Choose appropriate data types

9.      Incorporate integrity and security controls

d.      Database Normalization

i.           Allows Flexibility in implementing future data model changes

ii.           Contains a minimum of redundant data

iii.           Prevents insertion, deletion, and update anomalies

iv.           First Normal Form 1nf

v.           Functional Dependency

vi.           Second Normal Form 2nf

vii.           Third Normal Form 3nf

e.      Data Types

i.           Primitive

ii.           Complex

f.       Distributed database architectures

i.           Decentralized

ii.           Homogeneous

iii.           Heterogeneous

iv.           Implementation

1.      Data Replication

2.      Horizontal Partitioning

3.      Vertical Partitioning

4.      Combinations

g.      Protecting the database

i.           Security

ii.           Transaction Logging

iii.  Concurrency and Complex update controls

Attached Files: | - KVCC BUS205_BusSysAnalysis_Outline 23.pdf