Database Design: Normalization

Table of Contents

Database Design: Normalization

Review

Entities

Functional areas

Ordering Normalization

ER Model

Mapping to a Relational Model

Employee

Sales-Rep

Customer

Invoice

Line-Item

Part

Joins

Today

Normalization

Normal Forms

Normalization

Unnormalized Relations

Unnormalized Relation

First Normal Form

First Normal Form

1NF Storage Anomalies

Second Normal Form

Second Normal Form

Second Normal Form

Second Normal Form

1NF Storage Anomalies Removed

2NF Storage Anomalies

Third Normal Form

Third Normal Form

Third Normal Form

2NF Storage Anomalies Removed

Boyce-Codd Normal Form

Most 3NF Relations are also BCNF

Effectiveness and Efficiency Issues for DBMS

Example: Text Fields

Normalizing to death

Advantages of RDBMS

Advantages of RDBMS

Disadvantages of RDBMS

Assignment

Cookie ER diagram

Email: ray@sherlock.berkeley.edu

Home Page: http://sherlock.berkeley.edu

Download presentation source

View text as html