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

1.      Review

2.      1NF

3.      2NF

a.      Make New Tables to eliminate Partial Dependencies

b.      Reassign Corresponding dependent Attributes

c.      Requirements

4.      3NF

a.      Make New tables to eliminate Transitive Dependencies

b.      Reassign Corresponding Dependent Attributes

c.      Requirements

5.      Improving the design

a.      Evaluate PK assignments

b.      Evaluate Naming Conventions

c.      Refine Attribute Atomicity

d.      Identify New Attributes

e.      Identify New Relationships

f.       Refine Primary Keys as required for Data Granularity

g.      Maintain Historical Accuracy

h.      Evaluate using Derived Attributes

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 16.pdf