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
Cartesian Product
Join (Natural)
Other Joins and Renaming
Complex Queries
Exercises
Operations on Bags (and why we care)
Email: alon@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/alon
Download presentation source