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

1.      Review

2.      Conceptual Design

a.      Minimal data rule

b.      Steps

i.           Data analysis and requirements

1.      Information needs

2.      Information users

3.      Information sources

4.      Information constitution

ii.           ERM and Normalization

iii.           Data Model Verification

1.      Module

iv.           Distributed Database design

c.      DBMS Selection

i.           Cost

ii.           Features and tools

iii.           Underlying Model

iv.           Portability

v.           DBMS hardware requirements

3.      Logical Design

a.      Map conceptual model to logical

b.      Validate using normalization

c.      Validate using integrity constraints

d.      Validate against user requirements

4.      Physical design

a.      Define data storage

b.      Integrity and security

c.      Performance measurements

5.      Design strategies

a.      Top down

b.      Bottom up

6.      Centralized vs decentralized

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 27.pdf