3NF: Multivalued Dependencies

Table of Contents

3NF: Multivalued Dependencies

3NF

3NF (II)

Example

"Elegant" Workaround

Taking Advantage of 3NF

Taking Advantage of 3NF

Taking Advantage of 3NF (II)

Roadmap

Roadmap (II)

3NF Synthesis Algorithm

Equivalent Sets of FD's

Testing Equivalence

Testing Equivalence (II)

Example

A Dependency-Preserving Decomposition

Example

Dependency Preservation with Losslessness

Example

Not Covered

Multivalued Dependencies

Multivalued Dependencies (II)

Multivalued Dependencies (III)

Multivalued Dependencies (IV)

Multivalued Dependencies

Multivalued Dependencies (II)

Example

MVD Rules

Splitting Doesn't Hold

4NF

4NF (II)

Example

Example (II)

Email: burt@umbc

Home Page: www.cs.umbc.edu/~burt