Database Design: Normalization

10/1/98


Click here to start


Table of Contents

Database Design: Normalization

Review

Database Design Process

ER Diagrams: Entity

ER Diagrams: Attributes

ER Diagrams: Relationships

ER Diagrams: Relationships

ACME Widget Co. Entities

ACME Widget Co. Functional areas

ACME Widget Ordering Normalization

ACME Widget 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

Next Week

 Author: Ray R. Larson

Email: ray@sherlock.berkeley.edu

Home Page: http://sims.berkeley.edu/~ray

Download presentation source