Principles of Database Management Systems CSE 544
Staff
Course Times
Goals of the Course
Grading
Textbook
Other Useful Texts
Prerequisites
Real Prerequisites
Why Use a DBMS?
Functionality of a DBMS
Persistent Storage
Transaction Processing and Recovery
Physical vs. Logical Levels
The Relational Model
Logical Model Issues
Querying a Database
Issues in Query Languages
Query Optimization
Database Industry
Course (Rough) Outline
Course Outline (cont)
PPT Slide
Terminology
More Terminology
More on Tuples
Integrity Constraints
Keys
Foreign Key Constraints
Functional Dependencies
Some Obvious Properties of FD’s
Comparing Functional Dependencies
Closure Algorithm
Problems in Designing Schema
Relation Decomposition
Boyce-Codd Normal Form
Email: zives@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/zives
Download presentation source