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

1.      Final Exam Review

2.      Opening Case

3.      Overview

4.      Database and DBMS

a.      Database

i.           Application Domain Data

ii.           Schema/Metadata

1.      Organization of individual stored data items into groups like tables

2.      Associations among tables

3.      Details of individual data items

a.      Types

b.      Lengths

c.      Locations

d.      Indexing

4.      Access and content controls

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

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

Attached Files: | - KVCC BUS205_BusSysAnalysis_Outline 22.pdf