Integrity Constraints
Keys
Foreign Key Constraints
Functional Dependencies
Example Problem in Designing Schema
Relation Decomposition
Boyce-Codd Normal Form
Querying Relational Databases
Relational Algebra
Set Operations
Selection
PPT Slide
Projection
Cartesian Product
Join
Exercises
Tuple Relational Calculus
SQL Introduction
SQL Outline
Selections
Projections and Ordering Results
Joins
Disambiguating Attributes
Tuple Variables
First Unintuitive SQLism
Union, Intersection, Difference
Subqueries
Subqueries Returning Relations
Correlated Queries
Removing Duplicates
Conserving Duplicates
Aggregation
Grouping and Aggregation
HAVING Clause
Modifying the Database
Data Definition in SQL
Data Types in SQL
Creating Tables
Creating Indexes
Defining Views
A Different View
Updating Views
Non-Updatable Views
Email: zives@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/zives
Download presentation source