Chapter 5

Table of Contents

Chapter 5

The Relational Model

Relation

Equivalent Relational Terms

Functional Dependency

Functional Dependency Notation

Key

Combination Key

Normalization

Anomaly

Normal Forms

First Normal Form

Second Normal Form

Third Normal Form

Boyce-Codd Normal Form

Fourth Normal Form

Fifth Normal Form

Domain Key Normal Form

DK/NF Terms

DK/NF Example

DK/NF Example

DK/NF Example

Summary of Normal Forms

A ? B relationships

Summary of Relationships

Optimization

Email: wscacchi@ics.uci.edu

Home Page: http://www.ics.uci.edu/~wscacchi

Download presentation source