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

1.      Normalization - evaluating and correcting tables to minimize redundancy and anomalies

2.      Levels

a.      1NF

b.      2NF

c.      3NF

3.      Denormalization

4.      Terminology

a.      Tables/Relations

b.      Prime Attribute

c.      Nonprime Attribute/Nonkey

5.      Examining the example data

a.      Problems

i.           Primary Key contains nulls

ii.           Potential data inconsistencies

iii.           Anomalies

1.      Update

2.      Insertion

3.      Deletion

iv.           Entry problems

6.      The normalization process

a.      Well-formed relations

i.           Each table represents a single subject

ii.           No data item will be unnecessarily stored in more than one table

iii.           All nonprime attributes in a table are dependent on the primary key

iv.           No anomalies

b.      Normal forms

c.      Key Review

i.           Types of keys

1.      Primary

2.      Composite

3.      Super

4.      Candidate

7.      Functional dependence

a.      Levels

b.      Dependency

i.           Partial

ii.           Transitive

8.      Conversion to 1NF

a.      Repeating groups

b.      Steps

i.           Eliminate the Repeating Groups

ii.           Identify the Primary Key

iii.           Identify all dependencies

1.      Dependency Diagram

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 15.pdf