Relation Decomposition

10/11/99


Click here to start


Table of Contents

Relation Decomposition

Wild Decompositions

Not This Example, Again...

More Careful Strategy

Example Decomposition

A Problem

So What’s the Problem?

Solution: 3rd Normal Form

Multi-valued Dependencies

Summary of This Section

Summary Continued

More Summary

Summary Beyond This Section

Querying the Database

Relational Algebra at a Glance

Set Operations

Selection

PPT Slide

Projection

PPT Slide

Cartesian Product

PPT Slide

Join (Natural)

PPT Slide

Other Joins and Renaming

Complex Queries

Exercises

Operations on Bags (and why we care)

Author: Alon Levy

Email: alon@cs.washington.edu

Home Page: http://www.cs.washington.edu/homes/alon

Download presentation source