Database Design: Logical Model and Normalization

9/16/99


Click here to start


Table of Contents

Database Design: Logical Model and Normalization

Review

Database Design Process

Entities

Functional areas

Ordering

Ordering Normalization

DiveShop ER Diagram

Logical Design: Mapping to a Relational Model

Customer = DIVECUST

Dive Order = DIVEORDS

Line item = DIVEITEM

Shipping information = SHIPVIA

Dive Equipment Stock/Inventory = DIVESTOK

Dive Locations = DEST

Dive Sites = SITE

Sea Life = BIOLIFE

BIOSITE -- linking relation

Shipwrecks = SHIPWRK

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

 Author: Ray R. Larson

Email: ray@sherlock.berkeley.edu

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

Download presentation source